Monday, March 19, 2012

Does MSSQL service account rights

Does the MSSQL Service domain service account have to be a member of the
system administrators role?No - al permisions that it needs are listed in Books OnLine, topic "Setting
up Windows Services Accounts"
(mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\in
stsql.chm::/in_overview_6k1f.htm).
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Rod Bautista" <rod.bautista@.adam-us.com> wrote in message
news:Oq5Hx4KhEHA.1344@.TK2MSFTNGP11.phx.gbl...
> Does the MSSQL Service domain service account have to be a member of the
> system administrators role?
>|||Hi,
See the below link:-
http://support.microsoft.com/defaul...b;en-us;Q283811
Thanks
Hari
MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OyhMAFPhEHA.3612@.TK2MSFTNGP12.phx.gbl...
> No - al permisions that it needs are listed in Books OnLine, topic
"Setting
> up Windows Services Accounts"
>
(mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\in[vbc
ol=seagreen]
> stsql.chm::/in_overview_6k1f.htm).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Rod Bautista" <rod.bautista@.adam-us.com> wrote in message
> news:Oq5Hx4KhEHA.1344@.TK2MSFTNGP11.phx.gbl...
>[/vbcol]|||Yes.
It does not have to be a member of the operating system local
Administrators group, but needs to be part of the sysadmin fixed database
roll.

>On Tue, 17 Aug 2004 16:01:49 -0700, Rod Bautista wrote:

> Does the MSSQL Service domain service account have to be a member of the
> system administrators role?|||Thanks.
To clarify, I understand that the service account does not have to be a
local administrator on the machine, but does it have to be a member of the
sysadmin fixed server role?
I have a SQL Server that runs under a domain account. This SQL Server has
BUILTIN\Administrators removed from the system administrators role. The
domain account used to start the MSSQL service is not a member of the
sysadmin role. Curiously, the SQL Server runs without issue. This tells me
that membership in the sysadmin role is not required. However, if this same
account was used to start the SQL Server AGent, would it then be required to
have membership in the sysadmin role?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OyhMAFPhEHA.3612@.TK2MSFTNGP12.phx.gbl...
> No - al permisions that it needs are listed in Books OnLine, topic
"Setting
> up Windows Services Accounts"
>
(mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\in[vbc
ol=seagreen]
> stsql.chm::/in_overview_6k1f.htm).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Rod Bautista" <rod.bautista@.adam-us.com> wrote in message
> news:Oq5Hx4KhEHA.1344@.TK2MSFTNGP11.phx.gbl...
>[/vbcol]|||Yes. I think someone may have referred you to the following:
How to change the SQL Server or SQL Server Agent Service
account without using SQL Enterprise Manager in SQL Server
2000
http://support.microsoft.com/?id=283811
Check the Miscellaneous steps section.
-Sue
On Fri, 20 Aug 2004 09:14:18 -0700, "Rod Bautista"
<rod.bautista@.adam-us.com> wrote:

>Thanks.
>To clarify, I understand that the service account does not have to be a
>local administrator on the machine, but does it have to be a member of the
>sysadmin fixed server role?
>I have a SQL Server that runs under a domain account. This SQL Server has
>BUILTIN\Administrators removed from the system administrators role. The
>domain account used to start the MSSQL service is not a member of the
>sysadmin role. Curiously, the SQL Server runs without issue. This tells me
>that membership in the sysadmin role is not required. However, if this sam
e
>account was used to start the SQL Server AGent, would it then be required t
o
>have membership in the sysadmin role?
>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
>message news:OyhMAFPhEHA.3612@.TK2MSFTNGP12.phx.gbl...
>"Setting
> (mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\i
n
>|||Thanks for the clarification Sue.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:7poji0tj3pk1rv3tqab80aasfsh1kn8h6v@.
4ax.com...
> Yes. I think someone may have referred you to the following:
> How to change the SQL Server or SQL Server Agent Service
> account without using SQL Enterprise Manager in SQL Server
> 2000
> http://support.microsoft.com/?id=283811
> Check the Miscellaneous steps section.
> -Sue
> On Fri, 20 Aug 2004 09:14:18 -0700, "Rod Bautista"
> <rod.bautista@.adam-us.com> wrote:
>
the[vbcol=seagreen]
has[vbcol=seagreen]
me[vbcol=seagreen]
same[vbcol=seagreen]
to[vbcol=seagreen]
in[vbcol=seagreen]
> (mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\i
n
the[vbcol=seagreen]
>

No comments:

Post a Comment