Tuesday, February 14, 2012

Default Permissions

What are the default permissions required to run SQL 2000?
-Registry permissions and File and Dir permissions needed for
it to work. I have a server that is locked down by security policies.
thx.in adv.
NETNET,
This article lists the necessary privs and permissions:
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
-Sue
On Thu, 25 Mar 2004 15:38:07 -0500, "NETCRAMMER"
<netcrammer@.hotmail.com> wrote:

>What are the default permissions required to run SQL 2000?
>-Registry permissions and File and Dir permissions needed for
> it to work. I have a server that is locked down by security policies.
>thx.in adv.
>NET
>
>|||The KB below details registry and file permissions and rights required for
the service account
http://support.microsoft.com/?id=283811
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"NETCRAMMER" <netcrammer@.hotmail.com> wrote in message
news:eEDZVkqEEHA.576@.TK2MSFTNGP11.phx.gbl...
> What are the default permissions required to run SQL 2000?
> -Registry permissions and File and Dir permissions needed for
> it to work. I have a server that is locked down by security policies.
> thx.in adv.
> NET
>
>|||If you use Enterprise Manager to choose the account(s) used to start SQL
Server and SQL Server Agent then the permissions will all be granted to
that account automatically.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment