March 13, 2018 at 8:01 am
I am trying to change the logon account for the SQL Server Integration Services service and am getting the error:The MsDtsServer110 service was unable to log on as XXX\xxxxxxxxxx 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: MsDtsServer110
Domain and account: XXX\xxxxxxxxxx
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.
If you have already assigned this user right to the service account, and the user right appears to be removed, check with your domain administrator to find out if a Group Policy object associated with this node might be removing the right.
However the "SQL Server" and "SQL Server Agent" services are both using the same account and are running without issue. Consequently I can't see how the permissions on the account are incorrect. The account is also a member of the local administrators group.
Can anyone shed any light on what I'm missing?
Thanks.
March 13, 2018 at 8:23 am
Pete Bishop - Tuesday, March 13, 2018 8:01 AMI am trying to change the logon account for the SQL Server Integration Services service and am getting the error:The MsDtsServer110 service was unable to log on as XXX\xxxxxxxxxx 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: MsDtsServer110
Domain and account: XXX\xxxxxxxxxx
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.
If you have already assigned this user right to the service account, and the user right appears to be removed, check with your domain administrator to find out if a Group Policy object associated with this node might be removing the right.
However the "SQL Server" and "SQL Server Agent" services are both using the same account and are running without issue. Consequently I can't see how the permissions on the account are incorrect. The account is also a member of the local administrators group.
Can anyone shed any light on what I'm missing?
Thanks.
Are you using SQL Server Configuration Manager to change the account?
Sue
March 13, 2018 at 8:38 am
Hi Sue. Yes I am.
March 13, 2018 at 9:50 am
Hmm... Changing this through the normal services interface worked. When I set the account to use I got a message stating that the "log on as a service" right was being added. For whatever reason, this now worked.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply