Uninstall SQL 2000 Workstation Components

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jlaustill@gmail.com - 28 Mar 2008 15:03 GMT

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

Reply to this Message

Erland Sommarskog - 29 Mar 2008 00:19 GMT

> 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
[quoted text clipped - 3 lines]
> 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\Administrators from the sysadmin role, your
admin colleagues will be less able to that much, unless they have
personal accounts. You can even drop BUILTIN\Administrators entirely.

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

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.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

Reply to this Message

jlaustill@gmail.com - 31 Mar 2008 21:46 GMT

> jlaust...@gmail.com (jlaust...@gmail.com) writes:
> > Hey yall. I'm a DBA in a company where I do NOT have the ability to
[quoted text clipped - 26 lines]
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/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!

Reply to this Message