Re: Deny Builtin Administrators

Another administrator meaning a user who can log in who has admin privileges
in the database. You eliminated all Windows admins already unless you have
specifically granted permissions to a particular user before you denied
Windows admins and forgot the sa password.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"dusty" <dusty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5727AD5D-34FD-4FDC-A917-E6B1E237B0A5@xxxxxxxxxxxxxxxx
Okay. Another Administrator meaning...??? Domain Admin?

THanks for the prompt reply.

"Roger Wolter[MSFT]" wrote:

You're pretty well out of luck if you don't know the SA password and
don't
have another administrator. The only thing I can think of is to install
again from scratch and then attach the databases - and write down the SA
password this time.

--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"dusty" <dusty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:17A2CB2B-73F2-4DAA-8B18-FC4C636AC714@xxxxxxxxxxxxxxxx
I have denied the Builtin Administrators group with SQL Server, now I
don't
have access to recover. Everything seems to run okay, but I don't have
permission to do anything anymore. I don't know the password to the sa
account. This is on an Active Directory domain.

Now I can't start backup exec, b\c of dependencies.

Any help would be greatly appreciated.

Thanks in advance.





.