Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

could not start the SQL Server(MSSQLSERVER) Service on local computer. Expand / Collapse
Author
Message
Posted Monday, April 13, 2009 6:31 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, April 26, 2009 7:37 AM
Points: 87, Visits: 307
Hi,

I installed sql server 2005 on my machine i keep getting the following errors......when i start up the services I get the following services..

Could not start the SQL Server(MSSQLSERVER) Service on local computer.
Error 3: The system cannot find the path specified


an error has occured while establishing a connection to the server. when connecting to sql server 2005, this failure may be faused by the fact that under the default seetings Sql server does not allow remote connections.

How can I fix it



Post #695691
Posted Monday, April 13, 2009 12:07 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, March 10, 2014 9:39 AM
Points: 942, Visits: 1,050
Check to confirm the SQL Install completed successfully and your setup path information for the master database is correct.

You can you use "SQL Server Configuration Manager" to see the startup parameters for the SQLServer Service.

Mohit.


---

Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN.
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.


How to ask for help .. Read Best Practices here.
Post #696016
Posted Monday, April 13, 2009 3:28 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, April 26, 2009 7:37 AM
Points: 87, Visits: 307
These are the startup parameters in my Sql Server Configuration path

-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf

Dump Directory - C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\

I'm not sure if this is what you are refering to in your answer ? Does this look correct ? I've also attached the Settings for the following Sql ServerConfig manager, registry settings & Startup Menu Settings





  Post Attachments 
Sql Server Configuration manager.doc (169 views, 85.00 KB)
registrySettings.doc (135 views, 127.50 KB)
StartUpMenu Settings.doc (115 views, 121.00 KB)
Post #696168
Posted Monday, April 13, 2009 4:08 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, March 10, 2014 9:39 AM
Points: 942, Visits: 1,050
raym (4/13/2009)
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf


These are correct; but please go to that path C:\Program Files\Microsoft SQL Server\MSSQL.1\ and see if said files exist in the directories.

Looking at the screenshots you do got everything installed; but it doesn't tell me why it is not working. File path not found error indicates some directory or databaes it needs it cannot access. If it was a user database it would show up as suspect db; since your SQL fails to start I am assuming it can't see the master (system) database.

Mohit.


---

Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN.
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.


How to ask for help .. Read Best Practices here.
Post #696200
Posted Monday, April 13, 2009 4:20 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:35 AM
Points: 5,850, Visits: 12,597
An error log should be created each time it tries to start, any further info in those?

check out application view in eventvwr as well.

sounds like it might not be able to find the sqlervr.exe. which should be in

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn

is it there?

which file does the services applet for mssqlserver say it is trying to execute, and is it present?


---------------------------------------------------------------------

Post #696208
Posted Tuesday, April 14, 2009 12:21 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, April 26, 2009 7:37 AM
Points: 87, Visits: 307
You are right the file doesn't exist. Is it not supposed to copy the file during installation ? Do I have to re-install or I have to copty the file from the CD ?In the event viewer this is all I can pick up

NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002







  Post Attachments 
SQLDir.doc (63 views, 181.50 KB)
EventLog.txt (40 views, 294.21 KB)
Post #696324
Posted Tuesday, April 14, 2009 2:40 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:35 AM
Points: 5,850, Visits: 12,597
If the file does not exist who knows what may be missing as well. If this install has never run you have nothing to lose, I would uninstall\reinstall.

---------------------------------------------------------------------

Post #696368
Posted Tuesday, April 14, 2009 9:04 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, March 10, 2014 9:39 AM
Points: 942, Visits: 1,050
As George said re-install might be you only open; but from your previous screen shots some components did get installed.

When you were installing did by chance enter another folder for install location?

If not you might not be able to uninstall because not all the components are not there. You might have to look into manually uninstalling SQL Server's current install...

Have a look at http://support.microsoft.com/kb/909967/.

Thanks.


---

Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN.
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.


How to ask for help .. Read Best Practices here.
Post #696644
Posted Thursday, April 16, 2009 9:00 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, September 22, 2010 3:05 AM
Points: 83, Visits: 172
May be an error in the Windows installer package. You can try to install the last version of Windows installer. And reinstalling SQL Sever
Post #698550
Posted Thursday, April 16, 2009 3:33 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, April 26, 2009 7:37 AM
Points: 87, Visits: 307
Hi,

I unistalled sql and reinstalled it and it worked. Thank you very much



Post #698952
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse