Change Service Account SQL 2000 MSDE

#11

Have you seen these links?

Setting up Windows Services Accounts
http://msdn.microsoft.com/en-us/libr...4(SQL.80).aspx

Changing Passwords and User Accounts
http://msdn.microsoft.com/en-us/libr...0(SQL.80).aspx

How to change the SQL Server or SQL Server Agent service account without
using SQL Enterprise Manager in SQL Server 2000 or SQL Server Configuration
Manager in SQL Server 2005
http://support.microsoft.com/kb/283811

--
Ekrem Önsoy

<kalvin.tuel (AT) gmail (DOT) com> wrote

Quote:

I am trying to change the SQL Service account from LocalSystem on my
Win XP machine to a local account that I created. I have followed the
MS articles to give permission to this account on the C: drive, in the
registry and in Local Sec Policy. The service still won't start. I
get an "Access Is Denied" error when I try to start the service. I
used this account for SQL Server 2005 express with no problem, but
MSSQL just won't start. If I put the account in the administrators
group then the service will start, but it shouldn't be in the Admin
group.
Please help me Obi Wan Kenobi, you're my only hope.

Kalvin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Change Service Account SQL 2000 MSDE

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: Change Service Account SQL 2000 MSDE - 07-10-2008 , 02:34 PM