After Server restart Cant start SQL Service. Getting error :
Service: MSSQL$SQLEXPRESS
Domain and account: NT Service\MSSQL$SQLEXPRESS
This service account does not have the required user right "Log on as a service."
User Action
Assign "Log on as a service" to the service account on this computer. You can use Local Security Settings (Secpol.msc) to do this. If this computer is a node in a cluster, check that this user right is assigned to the Cluster service account on all nodes in the cluster.
In "log on as a service" window The buttton add User or Group is disabled.
So cant add any user/group ..
server: WindowsServer 2008 R2
Im connected throw remote desktop.
,Thanks
Try changing the service account to "Network Service"
Start - Admin Tools - Services or Start - Control Panel - Administrative Tools - Services
Find "Sql Server (SQLEXPRESS)" - Right Click - Properties
Select the Log On tab - click Browse - type "Network Service" - click "OK" - click "OK"
Right click "Sql Server (SQLEXPRESS)" - Start