Uninstall SQL 2000 Workstation Components

[jlaustill@gmail.com]

Hey yall. I'm a DBA in a company where I do NOT have the ability to
control who logs into my SQL servers as administrator, so I'm looking
for a way to uninstall the workstation components WITHOUT completely
uninstalling all of my instances. Does anyone know how to do this?
All I can find is the complete removal option in add/remove, and the
install cd setup doesn't have a remove function that I can find. Any
idea's?

The reason for wanting to do this is so that every tom dick and harry
that logs in as administrator doesn't have the ability to just open EM
and do what they please. I want to force people to log in from
another box so I can get tighter control over who can access my
databases. Any help is awesome, thanks!

Joshua Austill

[Erland Sommarskog]

Re: Uninstall SQL 2000 Workstation Components

jlaustill@gmail .com (jlaustill@gmai l.com) writes:

Hey yall. I'm a DBA in a company where I do NOT have the ability to
control who logs into my SQL servers as administrator, so I'm looking
for a way to uninstall the workstation components WITHOUT completely
uninstalling all of my instances. Does anyone know how to do this?
All I can find is the complete removal option in add/remove, and the
install cd setup doesn't have a remove function that I can find. Any
idea's?

That seems difficult. Short of simply deleting the files.

The reason for wanting to do this is so that every tom dick and harry
that logs in as administrator doesn't have the ability to just open EM
and do what they please. I want to force people to log in from
another box so I can get tighter control over who can access my
databases. Any help is awesome, thanks!

But if you do that, they have the powers to repair the installation.

But if you delete BUILTIN\Adminis trators from the sysadmin role, your
admin colleagues will be less able to that much, unless they have
personal accounts. You can even drop BUILTIN\Adminis trators entirely.

Just make sure that your own login is there and in sysadmin.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[jlaustill@gmail.com]

Re: Uninstall SQL 2000 Workstation Components

On Mar 28, 5:19 pm, Erland Sommarskog <esq...@sommars kog.sewrote:

jlaust...@gmail .com (jlaust...@gmai l.com) writes:

Hey yall. I'm a DBA in a company where I do NOT have the ability to
control who logs into my SQL servers as administrator, so I'm looking
for a way to uninstall the workstation components WITHOUT completely
uninstalling all of my instances. Does anyone know how to do this?
All I can find is the complete removal option in add/remove, and the
install cd setup doesn't have a remove function that I can find. Any
idea's?

>
That seems difficult. Short of simply deleting the files.
>

The reason for wanting to do this is so that every tom dick and harry
that logs in as administrator doesn't have the ability to just open EM
and do what they please. I want to force people to log in from
another box so I can get tighter control over who can access my
databases. Any help is awesome, thanks!

>
But if you do that, they have the powers to repair the installation.
>
But if you delete BUILTIN\Adminis trators from the sysadmin role, your
admin colleagues will be less able to that much, unless they have
personal accounts. You can even drop BUILTIN\Adminis trators entirely.
>
Just make sure that your own login is there and in sysadmin.
>
--
Erland Sommarskog, SQL Server MVP, esq...@sommarsk og.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.c om/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.c om/sql/prodinfo/previousversion s/books.mspx

Best advice I've gotten thus far. I've never gotten rid of builtin/
administrators before because at prior jobs I never had a reason to, I
guess now I do. That'll work nicely actually. Thank you!