Re: MSSQLServer Service Account
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 06/28/04
- Next message: sqlguy: "Weird table rights issue"
- Previous message: Hari Prasad: "Re: MSSQLServer Service Account"
- In reply to: Phil: "MSSQLServer Service Account"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 28 Jun 2004 05:25:57 -0600
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.
- Next message: sqlguy: "Weird table rights issue"
- Previous message: Hari Prasad: "Re: MSSQLServer Service Account"
- In reply to: Phil: "MSSQLServer Service Account"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|