Re: Security Policy for MSSQL service account.
- From: "Gerry Sinkiewicz" <sinkiege@xxxxxxxx>
- Date: Wed, 04 Apr 2007 19:46:13 GMT
"Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message
news:O23zI8VdHHA.4188@xxxxxxxxxxxxxxxxxxxxxxx
How to change service accounts for a clustered computer that is running
SQL Server
http://support.microsoft.com/kb/239885/en-us
The permissions/privileges are enumerated in the context of changing the
service account on a clustered instance.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Gerry Sinkiewicz" <sinkiege@xxxxxxxx> wrote in message
news:N4fPh.142$w41.48@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Does anyone have a link for the essential local security policy settings
that are needed by the domain account
that is used to start a clustered MS SQL Server 2000 instance?
I have been to MS Technet and not found a really explicit list of privs
as they relate to my problem.
Of course this has to do with the security guys wanting to deny local
logon, network logon, and terminal services access to the account.
Perhaps that is ok, but will the clustered instance still work?
Thanks, I did find that reference and a few others with similar information.
What will happen, because of the local administrator requirement, is an
exception will be issued
with a mitigation of strong passwords changed at frequent intervals (like
whenever MS OS patches are applied
would be a good time). That makes it once a month or less.
.
- References:
- Re: Security Policy for MSSQL service account.
- From: Geoff N. Hiten
- Re: Security Policy for MSSQL service account.
- Prev by Date: sql server installation on cluster failing
- Next by Date: Re: New to Clustering - 2003 Server Enterprise & SQL 2000
- Previous by thread: Re: Security Policy for MSSQL service account.
- Next by thread: Sql 2005 single user mode: change back to multi user ?
- Index(es):
Relevant Pages
|
