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.
yes, event viewer should have some information.
also, the ERRORLOG file in the sql server's folder can show some info,
also, the ERRORLOG file in the sql server's folder can show some info,
ASKER
This is the error log.
errorlog.txt
errorlog.txt
the error log is clear:
and the file is supposed to be here:
so, your startup fails because that master.mdf is not there.
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. ...
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
...
so, your startup fails because that master.mdf is not there.
ASKER
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 ...
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.
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.
ASKER
How do i check the startup account, No reinstallation has been done.
in the windows services, what is the logon account
ASKER
In the startup parameters of Sql Server the following is written.
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ master.mdf ;-eC:\Prog ram Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\E RRORLOG;-l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ mastlog.ld f
I can give the control through teamviewer.
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\
I can give the control through teamviewer.
ASKER
The os is windows 2003 server and the login account for that is Administrator
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks a million tonne.
Possibly there is something wrong with the user account that is used to start the services (incorrect password?)