Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked Server Expand / Collapse
Author
Message
Posted Saturday, January 19, 2013 3:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Saturday, January 19, 2013 6:10 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 12, 2014 2:04 PM
Points: 1,789, Visits: 1,014
read point 8
http://msdn.microsoft.com/en-us/library/aa560998.aspx


Jayanth Kurup
Post #1409195
Posted Wednesday, January 23, 2013 10:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 11:58 PM
Points: 173, Visits: 723
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 »

Add to briefcase

Permissions Expand / Collapse