Linked Server ( Get Data From Server)

• huuhieu004

  SSC-Addicted

  Points: 430

  More actions

  November 25, 2008 at 1:51 am

  #203312

  Hi all, I have a database setup on three Server. And a an application. I used SqlServer2005. Example model :

  Server A(DB) ServerC

  I created a linked server "SrvName".

  I use "SrvName" select data from A then insert into B ---> Ok. Select data from C then insert into B ---> Ok.

  But I can not select data from A insert into C.

  Question : 1.How I config A,B,C to select from A insert into B.

  2.I user workgroup is ok?

  3.Another username and password login is ok?(SQLServer of Server A (uid =sa;pwd = sa1)Server B (uid =sa;pwd = sa2) Server C(uid =sa;pwd = sa3)

  Thanks very much!

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  November 25, 2008 at 3:39 am

  #903011

  Hello,

  If you are using a specific set of credentials to access a Linked Server then the password that you use must be the one that exists on the remote server. I would not recommend using the “sa” account for this task, but if you do then you would probably want to have the same password on all three servers. You could also consider creating a Login Mapping to switch to the password of the remote servers “sa” account.

  BTW – Do you have a Linked Server registered on Server C, pointing to Server A?

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group

• krayknot

  SSCertifiable

  Points: 7998

  More actions

  November 25, 2008 at 3:56 am

  #903015

  huuhieu004 (11/25/2008)

  ---

  Hi all, I have a database setup on three Server. And a an application. I used SqlServer2005. Example model :

  Server A(DB) ServerC

  I created a linked server "SrvName".

  I use "SrvName" select data from A then insert into B ---> Ok. Select data from C then insert into B ---> Ok.

  But I can not select data from A insert into C.

  Question : 1.How I config A,B,C to select from A insert into B.

  2.I user workgroup is ok?

  3.Another username and password login is ok?(SQLServer of Server A (uid =sa;pwd = sa1)Server B (uid =sa;pwd = sa2) Server C(uid =sa;pwd = sa3)

  Thanks very much!

  1. create the link servers where these are required.

  2. use the servername as a prefix while doing any transaction.

  3. you require sa credentials for the creation of linked server

  kshitij kumar
  kshitij@krayknot.com
  www.krayknot.com