April 13, 2009 at 6:31 am
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
April 13, 2009 at 12:08 pm
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[/url].
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. :smooooth:[/font]
April 13, 2009 at 3:28 pm
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
April 13, 2009 at 4:08 pm
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[/url].
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. :smooooth:[/font]
April 13, 2009 at 4:20 pm
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?
---------------------------------------------------------------------
April 14, 2009 at 12:21 am
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
April 14, 2009 at 2:40 am
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.
---------------------------------------------------------------------
April 14, 2009 at 9:04 am
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[/url].
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. :smooooth:[/font]
April 16, 2009 at 9:00 am
May be an error in the Windows installer package. You can try to install the last version of Windows installer. And reinstalling SQL Sever
April 16, 2009 at 3:33 pm
Hi,
I unistalled sql and reinstalled it and it worked. Thank you very much
April 17, 2009 at 4:35 am
thanks for feeding back.
---------------------------------------------------------------------
July 7, 2011 at 1:57 am
Hi All,
The sql server Agent(MSSQLSERVER) service on local computer started and stopped.Some services automatically stop
if they have no work to do,eg the performance logs and alerts service.
Im getting above error while starting the sql server agent let me know what is the solution for this
July 7, 2011 at 3:33 am
2 yr old thread and an unrelated issue. Please post a new topic you will get more answers. Post the error in the sqlagent errorlog
---------------------------------------------------------------------
April 18, 2013 at 10:28 am
Mohit K. Gupta (4/13/2009)
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.
April 18, 2013 at 10:29 am
RESOLUTION
To resolve the problem, use these steps:
1.Change the startup account of both the MSSQLSERVER and SQLServerAgent to use the Local System account.
2.Restart the computer.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply