Hello everybody,
Did anyone of you know this problem?
Goal: I need to created a SQL 2005 link server using the radio button "[I]Be made using login's current security context"[/I]
Scenario 1: I created the link in my MMC client in my workstation and i encounter this error message.
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.SqlS erver.Connectio nInfo)
------------------------------
Login failed for user 'NT AUTHORITY\ANONY MOUS LOGON'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.co m/fwlink?ProdName =Microsoft+SQL+ Server&ProdVer= 09.00.3042&EvtS rc=MSSQLServer& EvtID=18456&Lin kId=20476
------------------------------
BUTTONS:
&Yes
&No
------------------------------
Scenario 2: But when I created the same link in the MMC of the server, I did not encounter any error. Why is that so? Could anyone help me on this?
Thank you in advance.
Did anyone of you know this problem?
Goal: I need to created a SQL 2005 link server using the radio button "[I]Be made using login's current security context"[/I]
Scenario 1: I created the link in my MMC client in my workstation and i encounter this error message.
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.SqlS erver.Connectio nInfo)
------------------------------
Login failed for user 'NT AUTHORITY\ANONY MOUS LOGON'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.co m/fwlink?ProdName =Microsoft+SQL+ Server&ProdVer= 09.00.3042&EvtS rc=MSSQLServer& EvtID=18456&Lin kId=20476
------------------------------
BUTTONS:
&Yes
&No
------------------------------
Scenario 2: But when I created the same link in the MMC of the server, I did not encounter any error. Why is that so? Could anyone help me on this?
Thank you in advance.