Symptoms
In Microsoft System Center Configuration Manager, you experience errors when you try to service a server group (cluster patching) on a child primary site that has a remote management point. Error messages that resemble the following are logged in the MP_ClientID.log file:
MPDB ERROR - EXTENDED INFORMATION
MPDB Method : ExecuteSP()
MPDB Method HRESULT : 0x80040E09
Error Description : The EXECUTE permission was denied on the object 'spGetLockState', database '<dbname>', schema 'dbo'.
Additionally, clients may send multiple "Topic ID 611, Type 611" state messages (.smx files).This causes a backlog in state message processing.
Note This problem was listed as resolved in Update Rollup 1 for Configuration Manager current branch, version 1606. However, the problem was not completely fixed.
Cause
When the current "Service a server group" feature is enabled, the required Execute permissions for remote management points are not applied correctly to the spGetLockState stored procedure.
Workaround
To work around this problem, use one of the following methods.
Method 1
Disable the "Service a server group" feature if you do not use it.
Method 2
Manually grant Execute rights for the management points to the spGetLockState stored procedure by using the following SQL script:
IF OBJECT_ID(N'spGetLockState') IS NOT NULL AND dbo.fnIsPrimary() = 1BEGIN GRANT EXECUTE ON [spGetLockState] TO [smsdbrole_MP]END