Linked Server ...behaving weird

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  June 12, 2009 at 4:34 am

  #138599

  Has anyone seen this error before? I'm getting it when I try to use or create link server. Here is some background. Today I moved our db to a new server. I installed SQL and moved the data and log folder from old server to new server.

  Everything works perfect except the link servers.

  TITLE: Microsoft SQL Server Management Studio

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

  Create failed for LinkedServerLogin ''. (SqlManagerUI)

  For help, click: http://go.microsoft.com/fwlink?ProdName ... nkId=20476

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

  ADDITIONAL INFORMATION:

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

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• sql_lock

  SSCrazy Eights

  Points: 9373

  More actions

  June 12, 2009 at 4:44 am

  #1008498

  If you are trying to authenticate with user that was created on the original SQL server you may to the "fixup" the login on the new server.

  See "sp_change_users_login" within BOL.

  i.e. EXEC sp_change_users_login 'Auto_Fix', 'UserName', NULL, 'password'

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  June 12, 2009 at 4:58 am

  #1008508

  yes

  i have done that already

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  June 12, 2009 at 5:16 am

  #1008519

  Thanks

  i got the solution

  i applied below written script

  ALTER SERVICE MASTER KEY FORCE REGENERATE

  and after i could make linked server

  Anyways ......thanks

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)