question

So, you are using a linked server in the query. Then there are several possibilities: You have SQL Server 2005 and you are affected by problem mentioned in the KB925001 - [FIX: Error message when you run queries between two SQL Server 2005 linked servers: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'"][1] Second option is that in the Security options of the Linked Server there is selected option that **`Connection will be made without security context`**. And the third possibility is that you are connecting to a Linked Server which is not on the same machine as your SQL Server instance and have security options se to **`Be made using the login's current security context`**, but you have not properly configured Kerberos to be able to pass the security tokens to the remote machine. So you have a few possibilities to solve this: 1. Map logins to remote logins in the Security tab of Linked Server 2. Do the connection using a predefined security context of remote user. 3. Use the current login's security context and setup the Kerberos authentication correctly. If the linked server is SQL Server, you can take a look on some articles related to Kerberos authentication: Techned: [Using Kerberos Authentication with SQL Server][2] SqlServerCentral: [Configuring Kerberos Authentication][3] MSDN: [Kerberos Authentication and SQL Server][4] [How to make sure that you are using Kerberos authentication when you create a remote connection to an instance of SQL Server 2005][5] [1]: http://support.microsoft.com/kb/925001/en-us [2]: http://technet.microsoft.com/en-us/library/cc280745(SQL.105).aspx [3]: http://www.sqlservercentral.com/articles/Security/65169/ [4]: http://msdn.microsoft.com/en-us/library/cc280744(v=sql.105).aspx [5]: http://support.microsoft.com/kb/909801/en-us