Delete Built-in Administrators From EM

[Asif Razzaq Attari]

I have deleted built-in Administrators from Enterprise Manager, Now I cannot
logon in Enterprise Manager. I am using SQL Server 2000 on Windows Server
2003.
How can I recover it now?
--
I like Microsoft Newsgroups, Which provides help me.

Thanks you Microsoft

[Erland Sommarskog]

Asif Razzaq Attari (AsifRazz...@discussions.microsoft.com) writes:
> I have deleted built-in Administrators from Enterprise Manager, Now I
> cannot logon in Enterprise Manager. I am using SQL Server 2000 on
> Windows Server 2003.
> How can I recover it now?

Do you know the sa password? If not, I believe you are hosed.

In SQL 2005 and later, you can recover from this situation by starting
SQL Server in single-user mode; you will now be able to connect as
system administrator, even if BUILTIN\Administrators has been dropped.
But I don't think this works in SQL 2000.

Note that your database are not lost. You can always reinstall SQL Server,
and your databases will still be there. Only the system databases will be
lost, that is logins and jobs.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Asif Razzaq Attari]

I know the sa password. What should I do next?

--
I like Microsoft Newsgroups, Which provides help me.

Thanks you Microsoft

"Erland Sommarskog" wrote:

> .
>

[Erland Sommarskog]

Asif Razzaq Attari (AsifRazz...@discussions.microsoft.com) writes:
> I know the sa password. What should I do next?

Right-click the server and select Edit SQL Server Registration Properties.