SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Error Code 3417. Cannot start Sql Server Service
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bhav27
Starting Member

8 Posts

Posted - 03/14/2008 :  05:34:20  Show Profile  Reply with Quote
Hi Guys

I have my Sql server 2005 running perfectly (until yesterday) on vista. But today when I tried to connect to the server I get error 3417 meaning my master database needs rebuilt or repaired.

I tried all sort of techniques I found on internet like checking if my data files in data dir are not compressed and for the SQL Server Servies it logs on local account with interact with desktop checkbox checked. But no luck.

I tried to use setup.exe in my installer CD to rebuild master database but it seems the cmd doing nothing. To rebuild, I use the following command “start /wait setup.exe /qn INSTANCENAME=<instance> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<New SA Password>”. This cmd runs but due to some reason my master db is not being repaired. Ideally, I should see recent date change for this file.

Please advice how can I connect back to my server again making sure my databases are not lost.

Edited by - bhav27 on 03/14/2008 05:45:38

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 03/14/2008 :  10:20:37  Show Profile  Reply with Quote
Do you have good full backup?
Go to Top of Page

maassql
Starting Member

13 Posts

Posted - 03/14/2008 :  12:22:49  Show Profile  Visit maassql's Homepage  Reply with Quote
1) backups
2) browse to directory on server which contains the mdf and ldf files
3) copy them off asap for safety's sake ( depending on size, free space you have available outside of the server )

When you do accomplish these things, they will be to no avail, until you first find the cause of the corruption:
a) begin to verify that your hardware's firmware and drivers are up to date
b) check Windows NT event logs for messages, research them
c) clean power to servers
etc, etc, etc !

Anything will give up its secrets if you love it enough. -- George Washington Carver
Go to Top of Page

bob2619s
Starting Member

United Arab Emirates
2 Posts

Posted - 12/16/2008 :  06:37:59  Show Profile  Reply with Quote
have install Primavera Ver 6.1 its need Sql server 2005 for database, which is running perfectly from last couple of month. Yestaday I found that is SQL server service is stop. When I try to start the services it give following error.

"Windows could not start the SQL Server(primavera) on local computer. For amore information, review the system Event log. If this is a non Microsoft service contact the services vendor, and refer to service-specific error code 3417."

Then I check with my colleague; he has reset the local admin password and from the same day SQL server stop working. I Again reset the old password, SQL server service and primavera start working.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000