Re: builtin/administrators
From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 08/17/04
- Next message: Subbaiahd: "Re: Intra-query parallelism caused deadlock"
- Previous message: Tibor Karaszi: "Re: builtin/administrators"
- In reply to: flologic: "builtin/administrators"
- Next in thread: Wayne Snyder: "Re: builtin/administrators"
- Reply: Wayne Snyder: "Re: builtin/administrators"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 17 Aug 2004 10:09:18 -0400
flo,
Here is an article (talking about clusters) that addresses some of your
concerns.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263712
One example of a side-effect that you must manage is:
http://support.microsoft.com/default.aspx?scid=kb;en-us;237604
Also, from the BOL on: Setting up Windows Services Accounts
If the startup account assigned to the MSSQLServer Service is not a member
of the Local Administrators group, or if the BUILTIN\Administrators SQL
Server login has been removed, you must add the startup account for the
MSSQLServer service or the SQLServerAgent service, or both, to the SQL
Server system administrators (sysadmin) role. Grant the [Domain\NTaccount]
user a logon to SQL Server.
Hope that helps you.
Russell Fields
"flologic" <flo@flo.net> wrote in message
news:eReee6FhEHA.632@TK2MSFTNGP12.phx.gbl...
> Hi, our sql box has too many people (including sql service account) with
> local admin rights, some even have domain admin rights. I am trying to
> tighten the security on those boxes and decrease the security level of
those
> people. What I am planning to do is take builtin/administrator login out
of
> the sql box, and add sql services account back and grant SA rights to it.
> Does anyone see any problem with this approach? Thanks.
>
>
- Next message: Subbaiahd: "Re: Intra-query parallelism caused deadlock"
- Previous message: Tibor Karaszi: "Re: builtin/administrators"
- In reply to: flologic: "builtin/administrators"
- Next in thread: Wayne Snyder: "Re: builtin/administrators"
- Reply: Wayne Snyder: "Re: builtin/administrators"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
