|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > Restoring Builtin\Administrator access
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Restoring Builtin\Administrator access
|
|
|
| I'm running Windows XP, stand alone PC. In the Microsoft
SQL Server directory I have 3 folders named 80, MSSQL
and MSSQL$MIP_ENGIN. In the SQL Server Group using SQL
Server Enterprise Manager I had a (local) server and a
DELL server (DELL being the name of my computer). The
MIP_ENGIN was under the DELL server. I removed the
windows access permissions from the
BUILTIN\Administrator, I know now, very stupid move. The
DELL\MIP_ENGIN serevr still shows and runs under SQL
Server Service Manager and the application still gets to
the tables. However DELL and DELL\MIP_ENGIN no longer are
displayed in the SQL Server Enterprise Manager window. If
I attempt to Register a new server with the name DELL I
get an error that it already exist.
1) Can I restore the rights to BUILTIN\Administrator?
2) Who created the server DELL? I tried uninstalling the
application that created the MIP_ENGIN server under DELL
and re-installing it but still no good.
3) How can I get rid of the DELL server registration and
then re-create it.
Thank you
Chuck
| |
| Sue Hoegemeier 2002-10-05, 9:09 pm |
| 1. If by removing windows access you mean you deleted the
BUILTIN\Administrator login from SQL Server, you can add it
back. If you can login as a sysadmin, you can use:
EXEC sp_grantlogin [BUILTIN\Administrator]
EXEC sp_addsrvrolemember @loginame = [BUILTIN\Administrator]
, @rolename = 'sysadmin'
2. DELL is likely your local server. I'm not clear on what
you did registering the servers.
3. In Enterprise Manager, right click and delete it.
-Sue
On Fri, 13 Sep 2002 10:46:06 -0700, "Chuck"
<cbutera@earthlink.net> wrote:
>I'm running Windows XP, stand alone PC. In the Microsoft
>SQL Server directory I have 3 folders named 80, MSSQL
>and MSSQL$MIP_ENGIN. In the SQL Server Group using SQL
>Server Enterprise Manager I had a (local) server and a
>DELL server (DELL being the name of my computer). The
>MIP_ENGIN was under the DELL server. I removed the
>windows access permissions from the
>BUILTIN\Administrator, I know now, very stupid move. The
>DELL\MIP_ENGIN serevr still shows and runs under SQL
>Server Service Manager and the application still gets to
>the tables. However DELL and DELL\MIP_ENGIN no longer are
>displayed in the SQL Server Enterprise Manager window. If
>I attempt to Register a new server with the name DELL I
>get an error that it already exist.
>1) Can I restore the rights to BUILTIN\Administrator?
>2) Who created the server DELL? I tried uninstalling the
>application that created the MIP_ENGIN server under DELL
>and re-installing it but still no good.
>3) How can I get rid of the DELL server registration and
>then re-create it.
>Thank you
>Chuck
|
|
|
|
|