January 19, 2013 at 3:27 am
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.
January 19, 2013 at 6:10 am
January 23, 2013 at 10:01 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply