October 19, 2007 at 12:13 am
Hi,
I have a remote server where in i have registered a server 'A' which intern has a linked server 'B' configured. I am able to see the tables in Liked server when i register Server 'A' with 'sa' but when i use local account it gives an error "Error 17: SQL Server does not exist or access denied"
Can some one tell me the reason why?
Thanks in advance...
October 19, 2007 at 8:18 am
What do you mean by your local account. Are you talking of Windows authentication mode? Also make sure the user is member of the users defined on your remote server and has read access granted.
Prasad Bhogadi
www.inforaise.com
October 20, 2007 at 9:19 am
Hi Rajesh....
If you are asking how to add a local account to view the linked server tables then you need to check out option Impersonate....anyways please find below points from microsoft. If this is not you want just ignore this:)
1.Expand a server group, and then expand a server.
2.Expand Security, and then click Linked Servers.
3.In the details pane, right-click the linked server to which the login will be added, and then click Properties.
4.On the Security tab, click the local login to add.
5.Optionally, select the Impersonate check box if the local login should connect to the linked server using its own user security credentials.
6.Enter the remote user and remote password with which the local login should connect to the linked server when not using the user's security credentials (Impersonate not selected).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply