Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have managed to install SQL2000 on Windows 2008 (Fun!) but have a small issue I cannot figure out.

When starting the MSSQL$2000 service with a domain account, the service fails to start reporting:

Windows could not start the MSSQL$SQL2000 service on Local Computer.
Error 5: Access Denied.

Starting it with the Local Service account is fine, any idea on what the cause might be?

share|improve this question

migrated from Nov 7 '11 at 15:41

This question came from our site for professional and enthusiast programmers.

up vote 1 down vote accepted

You have not set permissions on some NTFS folders that are used by SQL Server.

The "Local Service" account has local admin rights therefore it works.

They lazy fix is to make the domain account local admin too, which IIRC is easiest for SQL Server 2000 (not needed for SQL Server 2005+). Or ensure that rights are granted on the SQL Server install folder + all paths used for MDFs, LDFs and error logs

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.