Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

edit:

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

share|improve this question
    
Look in the Windows Event Log and the SQL Server error log in the file system. –  Jon Seigel Sep 30 '13 at 20:15
    
@JonSeigel Ok but which .evtx file should i look? there are 84 different .evtx file –  Timur Aykut YILDIRIM Sep 30 '13 at 20:16
    
Use the Event Log application in Control Panel\Administrative Tools. –  Jon Seigel Sep 30 '13 at 20:18
    
Is it possible this was an evaluation edition that has expired? –  Aaron Bertrand Sep 30 '13 at 20:21
    
@AaronBertrand i don't think so because i installed it long ago. Plus, i entered my key –  Timur Aykut YILDIRIM Sep 30 '13 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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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