August 10, 2009 at 6:23 am
Hi i couldnt able to restart sql browser
i am getting following error
-----------------------------------------------------------------------------
The SQLBrowser service was unable to log on as CVNT\Kumar with the currently configured password due to the following error:
Logon failure: the user has not been granted the requested logon type at this computer.
Service: SQLBrowser
Domain and account: CVNT\Kumar
This service account does not have the necessary 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.
If you have already assigned this user right to the service account, and the user right appears to be removed, a Group Policy object associated with this node might be removing the right. Check with your domain administrator to find out if this is happening.
-----------------------------------------------------------------------------
please help me
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 10, 2009 at 7:30 am
Set it back up in the SQL Configuration Manager. That should give the account permissions needed (I believe). It does for Server/Agent.
that's where I would start.
August 11, 2009 at 5:39 am
Ther are a number of ways you can add the 'Log on as a Service' right, and Service Manager is one of these.
However, if your site is controlling account rights via Group Policy Objects (GPOs) then the next GPO refresh will remove the manually-appiled rights.
The account you quoted (CVNT\Kumar) looks like it may be a personal account. I suggest you get a service account created for SQL Browser and get your windows admin people to give it the log on as a service right in a GPO. This will ensure your account keeps the rights it needs, and that SQL Browser does not stop working if Kumar changes their password.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply