Advertisement

05.21.2008 at 10:41PM PDT, ID: 23423362
[x]
Attachment Details

Service will not start

Asked by donpick in MS SQL Server

Tags: microsoft, sql server, 2000, Service will not start

URGENT QUESTION:

Running SQL Server 2000 which has service pack 4 running on a Windows 2000 server fully patched.  I just installed SQL Server today.

SQL Server databases are installed in  a directory called MSSql on drive D.

SQL Server is set to Windows authentication only.  The MSsql service logs into the administrator account .

The problem:
-      The SQL Server service will not start.  The problem involves security.  If I add EVERYONE to the security settings to the MSSQL folder on drive D and give EVERYONE full control then the service will start.

I dont want EVERYONE on the security list.  I just want the following:
-      domain admin
-      domain users
-      administrator (built in)

What must I do to be able to remove EVERYONE from the security list?

Start Free Trial
[+][-]05.21.2008 at 10:53PM PDT, ID: 21621240

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.21.2008 at 11:48PM PDT, ID: 21621460

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.21.2008 at 11:52PM PDT, ID: 21621470

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 01:56PM PDT, ID: 21627554

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 04:59PM PDT, ID: 21628533

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: microsoft, sql server, 2000, Service will not start
Sign Up Now!
Solution Provided By: debuggerau
Participating Experts: 3
Solution Grade: A
 
 
[+][-]05.26.2008 at 02:00PM PDT, ID: 21648082

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628