Sql-server – MS Sql Server Management Studio gives error on start

sql serversql-server-2008-r2

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

Best Answer

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.

Related Question