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.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@.discussions.microsoft.com> wrote in message
news:17A2CB2B-73F2-4DAA-8B18-FC4C636AC714@.microsoft.com...
>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.|||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@.discussions.microsoft.com> wrote in message
> news:17A2CB2B-73F2-4DAA-8B18-FC4C636AC714@.microsoft.com...
>
>|||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@.discussions.microsoft.com> wrote in message
news:5727AD5D-34FD-4FDC-A917-E6B1E237B0A5@.microsoft.com...[vbcol=seagreen]
> Okay. Another Administrator meaning...? Domain Admin?
> THanks for the prompt reply.
> "Roger Wolter[MSFT]" wrote:
>|||Yes, I was sure that's what you meant, but just wanted to confirm. Thanks
for your help Roger.
"Roger Wolter[MSFT]" wrote:
> Another administrator meaning a user who can log in who has admin privileg
es
> in the database. You eliminated all Windows admins already unless you hav
e
> 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@.discussions.microsoft.com> wrote in message
> news:5727AD5D-34FD-4FDC-A917-E6B1E237B0A5@.microsoft.com...
>
>
No comments:
Post a Comment