When i try to connect my sa account on sql server management studio it gives me this error:

*ps: the error message is turkish but you will see english version in 3rd image

enter image description here

Then i clicked on "Get Help For" thing as its shown above. It showed me this:

enter image description here

So i clicked to "Yes" button. Then it opened web page below:

*ps: error message is the same in first image but its english.

enter image description here

After that, i tried to start sql server process in services windows regarding 3rd image. But it gave me this error message:

It means "Windows couldn't start SQL SERVER service on local computer. For more information see event logs. If this is not a Microsoft service, call provider and give this special error code: 3417"

I wanted to look system event logs from C:\Windows\System32\winevt\Logs directory but there was 84 different .evtx files, I couldn't know what to do. How can i fix this?

*ps: I'm also not little bit confused about this problem's scope. I also thought to post this on superuser and/or stackoverflow but this place looked more convenient to me. So, if i'm mistaken please warn me.

enter image description here


I opened Event Log application in Control Panel\Administrative Tools according to Jon Siegel's suggestions and filtered all event logs from MSSQLSERVER source. There are 2 different error event.Below you can see event properties and link for event log online help documents.

Error 1: enter image description here

Event Log Online Help Document for Error 1: Link

Error 2: enter image description here

Event Log Online Help Document for Error 2: Link 2

  • Look in the Windows Event Log and the SQL Server error log in the file system.
    – Jon Seigel
    Sep 30, 2013 at 20:15
  • @JonSeigel Ok but which .evtx file should i look? there are 84 different .evtx file
    – t1w
    Sep 30, 2013 at 20:16
  • Use the Event Log application in Control Panel\Administrative Tools.
    – Jon Seigel
    Sep 30, 2013 at 20:18
  • Is it possible this was an evaluation edition that has expired? Sep 30, 2013 at 20:21
  • @AaronBertrand i don't think so because i installed it long ago. Plus, i entered my key
    – t1w
    Sep 30, 2013 at 20:24

1 Answer 1


Error code 3417 means that you have problems with your master database. More detailed information on this error can be found here: (http://msdn.microsoft.com/en-us/library/aa337262%28v=sql.105%29.aspx). The list of SQL server errors can be found in the MSDN by following address: http://msdn.microsoft.com/en-us/library/cc645601(v=sql.105).aspx. The solution is to recover the master database from the last backup. After this the SQL server will start and you will be able to connect.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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