Create linked server with Windows Authentication rights

• coby_cai

  SSC-Addicted

  Points: 439

  More actions

  January 19, 2012 at 1:44 am

  #391350

  Dear all,

  I have a Windows Domain account to connect to a SQL Server database with Windows Authentication for queries. But I don't know how to use it to create a linked server with the Windows Domain account.

  I appreciate if you can help me on this.

  Thanks,

  Coby

• padhis

  SSCommitted

  Points: 1762

  More actions

  January 19, 2012 at 5:07 am

  #1435738

  Here is a detail step for creating linked server.

  http://www.sqlservercentral.com/articles/Distributed+Queries/anintroductiontolinkedservers/1366/

• coby_cai

  SSC-Addicted

  Points: 439

  More actions

  January 19, 2012 at 5:58 pm

  #1436255

  Thank you, Padhis. That is quite helpful.