Stored Proc not using my user ID

• dwilliscp

  SSCrazy Eights

  Points: 9270

  More actions

  May 24, 2012 at 2:21 pm

  #392344

  Could someone please tell me why this works differently on the server and my desktop?

  I have a stored proc that gets data from several servers...

  For some reason when I use my SQL Server user ID, from my desktop using MS SQL Server Management Studio 2005, I keep getting "Login failed for user 'NT Authority\Anonymous Login' "

  but when I log into the server .. where the stored Proc is and run it, again using MS SQL Server Management Studio 2005 and the same SQL login.. no problem!

• Geoff A

  SSChampion

  Points: 11511

  More actions

  May 24, 2012 at 2:54 pm

  #1492826

  sounds like the stored procedure might be using linked servers. you might want to check what security the linked servers are using.