Re: Uninstall SQL 2000 Workstation Components
am 31.03.2008 22:46:46 von jlaustillOn Mar 28, 5:19 pm, Erland Sommarskog
> jlaust...@gmail.com (jlaust...@gmail.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\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.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/down loads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/boo ks.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!