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!
Best Answer
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.