ChrisRG


Hi,

I am trying to connect to a sql 2005 SP2 windows auth server through linked server from a sql 2005 SP2 mixed mode. I am using the "use current users credentials" option for authentication. I am getting the error below. Any thoughts to why this is happening would be appreciated.

TITLE: Microsoft SQL Server Management Studio
------------------------------

"The linked server has been updated but failed a connection test. Do you want to edit the linked server properties "

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server, Error: 18456)




Re: SQL 2005 Linked Server connection issues

Sankar Reddy


You are connecting from Mixed Mode (say server B) to Windows Authentication (server A) with current user credentials How are you connecting to server B with windows authentication or Sql authentication And what is the state for the error message. Also check this link for more details as you gave us very little information.

http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx






Re: SQL 2005 Linked Server connection issues

ChrisRG

I am connection using a domain account. Here is the error state Error: 18456, Severity: 14, State: 11.






Re: SQL 2005 Linked Server connection issues

Sankar Reddy

Now that we have idenitified the problem, can you check these two posts that explain solutions to this problem. May be your problem is related to these.

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=631415&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=609269&SiteID=1





Re: SQL 2005 Linked Server connection issues

Vidhya Sagar

Add the domain account in the destination server (ie. server B -- to which you are connecting thru linked server) and provide necessary privileges for databases you need to access.