Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 ID no longer has the admin group

Author  Topic 

CanadaDBA

583 Posts

Posted - 2004-11-16 : 08:17:34
I was not able to login to one of our test servers and our network admin says that the ID no longer has the admin group. She says "something you are running is stripping this group out of this ID." and suggests me to check this every time I run something on the sql server to identify what is doing this...

How this is possible? Is she right?

Canada DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-11-16 : 18:27:10
What ID is she referring to? Are you referring to the BUILTIN\Administrators group in sysadmin fixed server role in SQL Server?

Tara
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-11-16 : 20:18:46
quote:
Originally posted by farhadr

I was not able to login to one of our test servers and our network admin says that the ID no longer has the admin group. She says "something you are running is stripping this group out of this ID." and suggests me to check this every time I run something on the sql server to identify what is doing this...

How this is possible? Is she right?

Canada DBA



i'm a bit slow but i can't understand the question, how can you remove an ID from a group? what login are you using? did you check if the group Tara mentioned still there? or is it a domain account?

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -