December 13, 2004 at 5:38 pm
Hello,
I have attempted to set up a linked server in SQL Server 2000 from Enterprise Manager. Once I have the linked server set up, I get the following error message when I try to view the tables from the linked server in the EM;
Error 18452: Login failed for user '(null)'. Reason: not associated with a trusted SQL Server connection.
The names of the server machine I am trying to link to, and the name of the SQL Server instance are both 'SDO-SIS'. The server I am linking to and the one I am linking from are both in the same domain; 'valverde'.
In the security settings for the linked server, I have 'valverde\cdunn' set up as the local login and 'Impersonate' is checked. The domain user 'valverde\cdunn' has a login to SDO-SIS and is a user for the database I am trying to query against.
What else can I check to determine why I am getting this error?
Thank you for your help!
CSDunn
December 14, 2004 at 10:09 am
You can't impersonate Windows NT account in your configuration. To use Windows NT domain accounts (mapped to themselves) with linked servers you have to configure security account delegation. Your server has to be Windows 2000 (or 2003) in domain with Active Directory with Kerberos support enabled. For configuration you will use setspn utility. Configuration is a bit complicated.
Another way is to link you NT domain account to SQL account on linked server. Be sure this SQL account has the same permissions as NT account. Or just use SQL authentication, it's the simpliest way.
December 14, 2004 at 10:20 am
Thank you for your help. I'll try the set up with a SQL Account.
CSDunn
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply