Very Computer

Hi All,

I need to install SQL Server2000 on Win2000 machine member in Domain

The problem it's that i want to change the administrator user from the SQL
Service?

what user right i need for the New user?
what is the NTFS Permission i need to run the SQL Service(include the SQL
Agent)

any step by step guide?

Thanks for your help,,,
shahar.

During install, the account you choose to run the SQL
Service and SQL Agent Service under, will be automatically
given the necessary permissions and rights. You should
always change the service account via Enterprise Manager to
ensure that the necessary permissions and rights are assigned
to the service account.

--
HTH

Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

Quote:> Hi All,

> I need to install SQL Server2000 on Win2000 machine member in Domain

> The problem it's that i want to change the administrator user from the SQL
> Service?

> what user right i need for the New user?
> what is the NTFS Permission i need to run the SQL Service(include the SQL
> Agent)

> any step by step guide?

> Thanks for your help,,,
> shahar.

Hi Shakar,

You can get more information from this article as well:

HOW TO: Change the SQL Server Service Account Without Using SQL Enterprise
Manager in SQL Server 2000
ID: 283811.KB.EN-US
http://support.microsoft.com/support/kb/articles/q283/8/11.asp

Sincerely,
Yih-Yoon Lee
Microsoft, SQL Server

This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.