Re: NT Administrators group

From: Skip Shaw (sqlskip_at_hotmail.com)
Date: 06/13/03 

Date: Fri, 13 Jun 2003 09:19:48 -0400

We do this in our environment. It's an easy win in terms of locking down
the server. You just need to add the appropriate NT accounts as logins
within SQL and grant whatever permissions are needed. This should solve the
problem for you without having to change application code.

Skip

"Markus Persson" <markus@NoSpamPlease> wrote in message
news:%23D042AaMDHA.2432@TK2MSFTNGP10.phx.gbl...
> Hi!
>
> How common is it that people administrating SQL Servers
> remove the BUILTIN/Adminstrators account?
> I am making an installer that queries a SQL Server several
> times during the installation and i am using sql-dmo and NT
> Authentication. I require the user to be in the Administrator group
> so that i will not need to ask for a SQL login and password.
>
> If removing the BUILTIN/Administrators account is a common way
> to tighten security then i will have to change my installer to ask for
login
> and password.
>
> Thanks for any reply
> /Markus
>
>

Relevant Pages