Setting up Linked servers under windows

• dwilliscp

  SSCrazy Eights

  Points: 9270

  More actions

  January 24, 2013 at 11:57 am

  #269722

  I am trying to set up linked servers under windows, but not having to remote desktop to the sql server. Our IT department set the new servers up as 'Windows Domain' only.... unlike the old.

  So just how do I set these up to work? When I try and use Local Login + Impersonate I get the following error... when not directly logged into the sql server.

  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)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

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

  BUTTONS:

  &Yes

  &No

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