5

I cannot start the SQL Server 2012 service. The event log says the service-specific error code is 3417.

In the Event Viewer:

The SQL Server (MSSQLSERVER) service terminated with the following service-specific error:
WARNING: You have until SQL Server (MSSQLSERVER) to logoff. If you have not logged off at this time, your session will be disconnected, and any open files or devices you have open may lose data.

I've changed the service logon account in the service properties but this error happened again.

I think the problem is in the master database, but I do not know what to do.

EDIT:

I've try Rebuild the Resource database but this error happened again!

mehdi
  • 196
  • 1
  • 1
  • 9

2 Answers2

8

That error is usually associated with the Master database, so you are on the right track. Does the service account have access to the directory where the Master database resides?

There should be some additional errors in either the SQL Server error log or the Windows event log that may narrow down the issue. Look for access denied messages or cannot find file messages associated with the master database and other system databases.

One other thing I have found on other sites is folder compression being a problem. Make sure SQL Server does not reside on a compressed folder or drive.

If that doesn't work, then rebuild as suggested.

Cougar9000
  • 1,538
  • 1
  • 13
  • 29
0

what has solved the error 3417 for me it is something very simple.

Before I apply patches I take note of the sql server service account and all the folders it has permissions in the server and the level of permissions.

then I apply the updates, as you can see on the picture below, BUT, before I hit the reboot button, I re-apply all the folders permissions to that account.

enter image description here

Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320