R
rafalgul
Hi Everyone.
I got a problem with automatic start of SQL Server 2014 on Windows Server 2012.
My "SQL Server Service" is configured to log on as a domain user SQL_Services which is configured with "Logon as a service" local security policy rights. Everything is ok until server restart. After startup my service is unable to start and generate errors in System Even Views (numbers 7041 , 7034 and 7000).
It points that it is a
"Logon failure: the user has not been granted the requested logon type at this computer"
and
"This service account does not have the required user right "Log on as a service" ".
After manually assigning a user account to "Logon as a service" security policy or retyping password in "Log On" tab in services.msc (which after correct password informs me about adding user rights to "logon as a service") everything is working again.
I don't need to tell how frustraiting it is that after every server restart we must retype that password service again and again. Where to search for problems ? My server is disabled from Domain GPO policy. Any ideas ? Any help would be appreciated
Continue reading...
I got a problem with automatic start of SQL Server 2014 on Windows Server 2012.
My "SQL Server Service" is configured to log on as a domain user SQL_Services which is configured with "Logon as a service" local security policy rights. Everything is ok until server restart. After startup my service is unable to start and generate errors in System Even Views (numbers 7041 , 7034 and 7000).
It points that it is a
"Logon failure: the user has not been granted the requested logon type at this computer"
and
"This service account does not have the required user right "Log on as a service" ".
After manually assigning a user account to "Logon as a service" security policy or retyping password in "Log On" tab in services.msc (which after correct password informs me about adding user rights to "logon as a service") everything is working again.
I don't need to tell how frustraiting it is that after every server restart we must retype that password service again and again. Where to search for problems ? My server is disabled from Domain GPO policy. Any ideas ? Any help would be appreciated
Continue reading...