1

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 generateerror image

I can't start my services my sql configuration manager.Here is error image when i start services from configuration manager enter image description here

When I check parameters path then I can't find MSSQL10.SQLEXPRESS\MSSQL\DATA\master.mdf in C:\program File\Microsoft SQL Server folder. Microsoft SQLfolder only contains two folders: 90 and 100.

Improve this question
  • 1
    Can you locate errorlog file open it in notepad and add the output in question. Or you can go to event viewer and see the application logs as to why SQL Server is not starting – Shanky Dec 25 '15 at 13:21
  • Search your drives for master.mdf and see if it exist. – user507 Dec 25 '15 at 13:53
  • What version of SQL Server Express are you using? 2012, 2014, 2016? Could you add the versions specific tag to your question? – John K. N. Jun 7 '17 at 6:26
4

you need to find the corresponding error in event viewer in windows log\application 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) enter image description here

you may also want to check in system logs in event viewer, in the service Control manager to find a related error.

enter image description here

Improve this answer
0

Have you try starting the server services through command prompt? if not, From a command prompt, enter the following command sqlservr.exe -s and replace with the name of the instance you want to start.

I hope this will help.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.