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] "Hari Prasad" wrote:
> 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
>
>
> "Rajeshpillai" <Rajeshpillai@discussions.microsoft.com> wrote in message
> news:05C8279A-5DAE-4796-AC61-2CA37CE07E77@microsoft.com...
> > 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
> > SQLDBA
>
>