Hello All,
I am having trouble with linked servers. I have a sql2005 server and a sql2008 server. Everything works fine when I am on the either sql server, but when I use Management Studio on my desktop I get the error below.
Thanks for any help you can provide.
TITLE: Microsoft SQL Server Management Studio
------------------------------
"The linked server has been created but failed a connection test. Do you want to keep the linked server?"
------------------------------
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)
Any guidance will be apprciated.
I am having trouble with linked servers. I have a sql2005 server and a sql2008 server. Everything works fine when I am on the either sql server, but when I use Management Studio on my desktop I get the error below.
Thanks for any help you can provide.
TITLE: Microsoft SQL Server Management Studio
------------------------------
"The linked server has been created but failed a connection test. Do you want to keep the linked server?"
------------------------------
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)
Any guidance will be apprciated.