all groups > sql server connect > august 2006 >
You're in the

sql server connect

group:

Not able to register server name using windows authentication - Ur


Re: Not able to register server name using windows authentication - Ur Hari Prasad
8/16/2006 12:00:00 AM
sql server connect:
Hi,

The Domain OS user you have logged in may not be in Administrator group of
SQL Server machine. If you are the admin you could open
the enterprisemanager -- security-- add the Login (Domain OS userin windows
authentication and try connecting/registering.

Thanks
Hari
SQL Server MVP


[quoted text, click to view]

Not able to register server name using windows authentication - Ur Rajeshpillai
8/16/2006 12:07:01 AM
Hi All,

My issue like that....

I have SQL Server 2000 enterprise edition installed as named instance. I
have configured mixed mode authentication also. But the problem is whne i try
to register my sql server usuing windows authentication i get the following
error message " Login failed for user '(null)' Not associated with a trusted
SQL Server connection".

But i am able to register server with sql authentication . I actually
registered with "sa" account. No issues.

Any one kindly give some solution or any kb article for reference.

Thanks

Rajeshpillai
Re: Not able to register server name using windows authentication Rajeshpillai
8/16/2006 8:22:01 PM
Hi Hari,

I dont think for registering instance name through enterprise manager
requires the domain user to be in administrator group of that server
box/machine. But any way i am all the way trying with my account only.
Because i am the DBA over here. So i have all privileges. But as i previously
said i am able to register instance name using sql account with out any
problem. The instance is name instance. Can you please help with some other
solution.



[quoted text, click to view]
AddThis Social Bookmark Button