Why SQL Server Service does not start?
I'm using Windows 8.1. I have successfully installed SQL Server Management Studio, but services can't be started in "Sql configuration Manager". I search on google about these errors,and try all possible solutions but I am not able to resolve my error. Here is my error when I open services.msc and try to start services then this error generate
I can't start my services my sql configuration manager.Here is error image when i start services from configuration manager
When I check the parameters path then I can't find why sql server won't start MSSQL10.SQLEXPRESSMSSQLDATAmaster.mdf in C:program FileMicrosoft SQL Server folder. Microsoft SQLfolder only contains two folders: 90 and 100.
you need to find the corresponding error in event viewer in windows logpplication find the error, one that the source is MSSQLServer and has happened, at the time you started the service. detail of this error will help you resolve the issue. (in the image below there is no error in it, it's just an information message, but in your case you may notice an error) you may also want to check in system logs in event viewer, in the service Control manager to find a related error. The reason could be # 2:Startup parameters have incorrect file path locations. This is another common cause of SQL Server Service startup failure. Let's assume that the master database is located on a drive and files of the database. Since the master database is a system database, SQL Service would fail to start.