Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com Nov 7 '11 at 15:41

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

add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.