Saturday, February 25, 2012

Accidentally disable admin login

Hi, I have accidentally disabled the Administrator account in Sql Server 2005 (Douh!) on my clients server (double Dough!) & now I can login to enable it.

The <BuiltIn\Administartors> account is still active, The accout i disabled was <Domain\Administrator> (forgot I was logined via Terminal server).

Any help/assistance would be much appreciate!!

Cheers,

Nez

HI, i was unable to delte this post so may as well put the answer here.

to enable it again i used the SQLCMD.exe in the ".../90/tools/binn" folder

sp_grantlogin etc...

Cheers

|||Appreciate your solution and feedback here, in this case you can take help of DAC too if there is no other route.

No comments:

Post a Comment