April 13, 2004 at 12:32 pm
After creating a linked server in EM on my Local server, I can see the tables and views that I have permission to on the linked server. However, after creating a linked server from my Test server, I can not see the same tables and views. I get Error 18456: Login Failed for user 'NT Authority\Anonymous Login'. I have tried all kinds of security settings on in the Properies of the linked server without any luck. Does anyone know how to make this work?
TIA
Dean
April 13, 2004 at 12:39 pm
You should check to see, within the linkedserver security settings, if you are mapping logins to remote logins. You might be attempting to pass through the account you are logging onto the server with, which doesn't work.
April 14, 2004 at 5:34 am
We have had problems when trying to link servers with our NT accounts. You might try using a sql account for the mappings and see if that works.
April 14, 2004 at 9:26 am
Two possibilities:
Domain trust. If the server is in domain A, the login is DomainB\username, and there is no trust between domain A and B, this will occur.
NT 4 Domains. NT 4 domains will not passthrough credentials. So, if you use integrated authentication on your local server and you are trying to pass this authentication on to the linked server, this will occur.
To fix this, you can either upgrade to Active Directory (most secure), or most likely, add mappings to use a SQL login to the linked server (easiest).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply