can't connect to linkedserver

• bkshn

  Right there with Babe

  Points: 794

  More actions

  November 6, 2013 at 5:25 am

  #284566

  Hello

  I create my new linked server and an user for it with a username and password.

  but I can't connect to sql server and I have bellow error

  TITLE: Microsoft SQL Server Management Studio

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

  The test connection to the linked server failed.

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

  ADDITIONAL INFORMATION:

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

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

  Login failed for user 'ticket'. (Microsoft SQL Server, Error: 18456)

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  November 6, 2013 at 5:30 am

  #1664417

  go to the errorlog of the target server and see if there any login failure messages.

  looks like either invalid ID, password, or id 'ticket' is not defined to the target server.

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