Linked Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Linked Server

Linked Server

Rate Topic

Display Mode

Topic Options

Author

Message

sooraj.tk

Posted Saturday, January 19, 2013 3:27 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 5:11 AM
Points: 1, Visits: 3

I am trying to create a linked server in my local database "SQL_Server2" To "SQL_Server1".

Only Option to connect to "SQL_Server1" is my Network Domain User : "RCP\TK". User TK have only Read access to "SQL_Server1"

Now I want to create a Linked server to access databases on "SQL_Server2". After creating linked server, I need to access linked server with user "sa"

Please help.

Post #1409172

Jayanth_Kurup

Posted Saturday, January 19, 2013 6:10 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:43 AM
Points: 1,785, Visits: 1,008

read point 8
http://msdn.microsoft.com/en-us/library/aa560998.aspx

Jayanth Kurup

Post #1409195

faisalfarouqi

Posted Wednesday, January 23, 2013 10:01 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 11:53 PM
Points: 74, Visits: 466

I think you seem to be a bit confused here. If you want to create a linked server from suppose server a to server b, as you mentioned the only way you can access server b is through your login, and you do have read access for the db's on server b. If that's the case then you can use an option "Be made under the login's current security context" which you can find under the security tab for linked server. Your user login credentials should be same on both server a and server b.

Now, if you want to access server b from server a specifically using "sa", then you should understand that the password on server a and server b should both be same. You can use the option "Be made using this security context" this is also the last option under security tab...provide remote login details = "sa", and password for the same. Once created test the connection for success.

Regards,
Faisal

Post #1410692

« Prev Topic | Next Topic »

Permissions