Link to home
Start Free TrialLog in
Avatar of searchsanjaysharma
searchsanjaysharma

asked on

How to start the sql server services.

I have Sql Server 2005. When i click on Manage, Services and Sql server configuration manager , Sql Server 2005 Services, Services are unable to start.
Avatar of kriscoady
kriscoady
Flag of Netherlands image

What does the event viewer say when you try to start the services?
Possibly there is something wrong with the user account that is used to start the services (incorrect password?)
Avatar of Guy Hengel [angelIII / a3]
yes, event viewer should have some information.
also, the ERRORLOG file in the sql server's folder can show some info,
Avatar of searchsanjaysharma
searchsanjaysharma

ASKER

This is the error log.
errorlog.txt
the error log is clear:
2012-09-03 16:27:15.17 Server      Error 3(The system cannot find the path specified.) occurred while opening file 'master.mdf' to obtain configuration information at startup. ... 

Open in new window


and the file is supposed to be here:
2012-09-03 16:27:15.17 Server      Registry startup parameters:
2012-09-03 16:27:15.17 Server      	 C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
...

Open in new window


so, your startup fails because that master.mdf is not there.
The master.dbf is at that location only.
the error message tells otherwise.
so, are you 200% sure? often, after a reinstallation for example, the path is not MSSQL.1, for example, but something else ...
The master.dbf is at that location only.
If you are certain of this, can you also confirm that the startup account for the SQL Server service has access to this folder and the files.
How do i check the startup account, No reinstallation has been done.
in the windows services, what is the logon account
In the startup parameters of Sql Server the following is written.

C:\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

I can give the control through teamviewer.
The os is windows 2003 server and the login account for that is Administrator
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks a million tonne.