Were you running the query from the source server (ie the server where linked server is setup) ? If you are running from a client then delegation needs to be setup for the windows authentication to be carried to the linked servers. Just to verify this run the query from the server (ie EM on the server ).