Sys Admin cant access SQL server. Only SA account can?

[m]

Hi All hope you can help.

I have a SQL 2k Standard Ed. SP3 server that is in mixed security
mode.
I have logged into EM with the sa account.
Then added a Active Directory group (i.e. Domain\DBAdmins) to the
System Administrators for that server.
When I try and modify the SQL server registration in EM to use trusted
authentication instead of sa I get a connection failed. Any ideas?

Thanks,

[M A Srinivas]

Try logging out of NT and logging in again

Srinivas

MC****@YAHOO.COM (m) wrote in message news:<8f**************************@posting.google. com>...

Hi All hope you can help.

I have a SQL 2k Standard Ed. SP3 server that is in mixed security
mode.
I have logged into EM with the sa account.
Then added a Active Directory group (i.e. Domain\DBAdmins) to the
System Administrators for that server.
When I try and modify the SQL server registration in EM to use trusted
authentication instead of sa I get a connection failed. Any ideas?

Thanks,

[m]

I have tried logging out still have a trusted connection failure.

Matt

ma***@vsnl.com (M A Srinivas) wrote in message news:<f7**************************@posting.google. com>...

Try logging out of NT and logging in again

Srinivas

MC****@YAHOO.COM (m) wrote in message news:<8f**************************@posting.google. com>...

Hi All hope you can help.

I have a SQL 2k Standard Ed. SP3 server that is in mixed security
mode.
I have logged into EM with the sa account.
Then added a Active Directory group (i.e. Domain\DBAdmins) to the
System Administrators for that server.
When I try and modify the SQL server registration in EM to use trusted
authentication instead of sa I get a connection failed. Any ideas?

Thanks,

[Simon Hayes]

MC****@YAHOO.COM (m) wrote in message news:<8f**************************@posting.google. com>...

Hi All hope you can help.

I have a SQL 2k Standard Ed. SP3 server that is in mixed security
mode.
I have logged into EM with the sa account.
Then added a Active Directory group (i.e. Domain\DBAdmins) to the
System Administrators for that server.
When I try and modify the SQL server registration in EM to use trusted
authentication instead of sa I get a connection failed. Any ideas?

Thanks,

It sounds like you followed the correct steps - if you use
sp_helpsrvrolemember, does it show the domain group in the sysadmin
role? If it does, then the most likely explanation is that your
Windows login is not in the Domin\DBAdmins group.

Simon