February 19, 2010 at 5:23 am
How can i create a link server from sql 2005 to sql 2005 by mapping a Windows login from serverA to SQL Login from ServerB ?
when i tried i get an error
Error 7416 - Access to the remote server is denied because no login-mapping exists
Here is what i did...
1. create link server with network name of sql server
2.server type = SQL SERVER
3. Security tab > Local Login = Windows Login, Remote Login = remote SQL Login, Remote sql pswd given
4.selecting the check box " Not To be Made "
February 19, 2010 at 5:26 am
i tried the option in security tab " Be made using the security context " and passed on sql login and pswd and it works but i think this will give default access to all users on local server to remote server with the previalges of sql login.
But i would like to restrict access to limited users on remote server witout enabling delegation or creating SPN, is it possible ?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply