Unable to start MSSQLSERVER service from sql server configuration manager
Hello, I tried moving the System databases,after changing the start up parameter to the new location i triedstarting the MSSQLSERVER
service.It runs successfully for few minutes and within few seconds it automatically stops. i am unable to open the SSMS.When ichecked error logs, this is detailed i found "The SQL Server Network Interface library successfully deregistered the Service Principal Name (SPN) [ MSSQLSvc/servername.domain] for the SQL Server service". Any suggestion could be appreciated!
The error message you stated in the original post is not really an error. The SPN registration/de-registration is a standard part of the server startup and shutdown. As I understand it, this is to allow proper kerberos authentication across servers within an active directory environment. I think you need to focus on the server service account and the permissions it has on the folder where you moved the database files to. I suspect that is where the problems stem from.
It is my understanding that the message you are reading is a normal message when SQL Service stops. Do you mind listing the steps you took to move your system databases? Also tell us which SQL version you are working with. Are there any other errors in your SQL Server error log and or Windows Event viewer?