Home > Archive > MS SQL Server > February 2006 > SQL Server register by Windows Account









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author SQL Server register by Windows Account
Bill

2006-02-06, 8:23 pm

Hi,
I am a SQL Server DBA. I meet a problem when trying to register a
server in Enterprise Manager. I have two windows account A and B in
different domains. Both are a member in domain admins.
I login Windows XP with account A and register a server D in EM. Then
I log off Windows and re-login by account B. At this time I can't
register the server D in EM with the account B. It always tried to
register the server D by account A. I searched the register on my
computer and didn't find the Default Windows Account used by EM. Right
now my account A is disabled but I can't use my account B to access
server D.
When trying to connect to server D by account A in windows
Authentication in EM or SQL Query Analyzer the error message is:
Login Failed for user '(null)', Reason: Not associated with a trusted
SQL Server connection.

The account B still can connect to other servers.
Thanks for any help!


Bill

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com