Solved

SQL Server 2005 service will not Start on Windows 7 computer

Posted on 2014-01-22
4
642 Views
Last Modified: 2014-02-06
Hello Experts,

I have an issue with the SQL Server 2005 service not starting on a Windows 7 computer.

When trying to start the service, it times out with a code 3417. A message then comes up saying that Administrative privileges are needed to start the Service. The current user is an Administrator. (This computer is in a remote location on a computer that I did not configure) I believe the user logged on has Administrator rights.

In Event Windows logs/System, there is not much info.

The description for Event ID from source Service Manager cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
SQL Server (MyInstance)
%%3417
The locale specific resource for the desired message is not present


The service is set to start using "Local System" so it should start regardless of the user right?

Can anyone see what is going on here?

Thanks!
0
Comment
Question by:Saxitalis
  • 2
  • 2
4 Comments
 
LVL 68

Expert Comment

by:Qlemo
ID: 39800529
The usual culprits are missing privileges in the folder the (system) DBs are stored, or the DB files being compressed.
Since the default account is Network Services, you should try if changing the service to use that user will work.
0
 

Author Comment

by:Saxitalis
ID: 39800810
Thanks for the comment Qlemo...

I can't see how to change the Service Account to "Network Services".

I know you can select this when SQL Server is being installed but there is not an option I can see to do this in the control panel applet Administrator Tools\Services or SQL Surface Area Configurations.

Any Ideas?

Thanks!
0
 
LVL 68

Accepted Solution

by:
Qlemo earned 500 total points
ID: 39800865
Use the Service applet instead, as you would do with any other service.
0
 

Author Closing Comment

by:Saxitalis
ID: 39840657
It didn't appear to be privileges - I ended up uninstalling and re-installing the instance to fix it
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

First some basics on Windows 7 Backup.  It has 2 components one is a file based backup which is stored in .zip files each zip is split at around 200 Megabytes and there is the Image Backup which is as the name implies a total image of the partition …
A quick guide on how to use Group Policy to create a custom power plan and set it active on Windows 7.
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now