MSSQLServer Service Account

Hi,
We have an automated process which imports a file from a
remote server. Unfortunately this requires the
MSSQLServer service to be running under a domain account
in order to be able to access the remote server. I have
been unable to get SQL Server to start with anything other
than Domain Admin rights.
Do you know what rights are required for the MSSQLServer
service to run?
Thanks,
Phil.Hi,
Requirements for Domain User Account
All domain user accounts must have permission to:
Access and change the SQL Server directory (\Program Files\Microsoft SQL
Server\Mssql).
Access and change the .mdf, .ndf, and .ldf database files.
Log on as a service.
Read and write registry keys at and under:
HKEY_LOCAL_MACHINE\Software\Microsoft\MS
SQLServer.
-or- for any named instance service:
HKEY_LOCAL_MACHINE\Software\Microsoft\Mi
crosoft SQL Server.
HKEY_LOCAL_MACHINE\System\CurrentControl
set\Services\MSSQLServer.
-or- for any named instance:
HKEY_LOCAL_MACHINE\System\CurrentControl
set\Services\MSSQL$Instancename.
HKEY_LOCAL_MACHINE\Software\Microsoft\Wi
ndows NT\CurrentVersion\Perflib.
In addition, a domain user account must be able to read and write
corresponding registry keys for these services: SQLAgent$InstanceName,
MSSearch, and MSDTC.
SQL Server startup user should be:-
Member of local Power Users or local Administrators group
SQL Server Agent should be :-
Member of the Administrators local group
Create CmdExec and ActiveScript jobs belonging to someone other than a SQL
Server administrator.
Thanks
Hari
MCDBA
"Phil" <anonymous@.discussions.microsoft.com> wrote in message
news:2273a01c45cfd$6a7f85c0$a001280a@.phx
.gbl...
> Hi,
> We have an automated process which imports a file from a
> remote server. Unfortunately this requires the
> MSSQLServer service to be running under a domain account
> in order to be able to access the remote server. I have
> been unable to get SQL Server to start with anything other
> than Domain Admin rights.
> Do you know what rights are required for the MSSQLServer
> service to run?
> Thanks,
> Phil.|||If you change the service accounts using Enterprise Manager,
the rights and permissions are handled for you. Otherwise
you need to manage these manually and follow this article:
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 Mon, 28 Jun 2004 03:48:15 -0700, "Phil"
<anonymous@.discussions.microsoft.com> wrote:

>Hi,
>We have an automated process which imports a file from a
>remote server. Unfortunately this requires the
>MSSQLServer service to be running under a domain account
>in order to be able to access the remote server. I have
>been unable to get SQL Server to start with anything other
>than Domain Admin rights.
>Do you know what rights are required for the MSSQLServer
>service to run?
>Thanks,
>Phil.