Issue
Each time a SQL job tries to execute, the following error occurs in the Windows System Event log:

Product Line

ION Enterprise 6.0x

Power Monitoring Expert 7.0.1

Power Monitoring Expert 7.2.x

Power Monitoring Expert 8.x
Power Monitoring Expert 9.0

Environment
Power Monitoring Expert Server
Windows Component Services

Cause
The SQL Server Agent service lacks the Local Activation permission for the MsDtsServer100 DCOM application. This typically happens when the SQL Server Agent service is configured using a domain user account, or is not a
member of the Administrators group.

Resolution
*Warning: This article contains information about editing the registry. Improper changes to the registry can permanently damage the operating system. Always backup the registry before making any changes.*

One solution would be to add the SQL Server Agent service account to the Local Administrators group on the server; however, this is not always allowed per the user's specific security requirements. To add an account to the Local Administrators group:

1. From the Windows start menu, type lusrmgr.msc and hit Enter to open the Edit Local Users and Groups interface.
2. Select Groups on the left, then right-click on the Administrators group and select Properties.
3. Click Add and then type the name of the user running the SQL Server Agent service, click Check Names, and hit OK.

Another solution would be modifying the Local Activation permission for the MsDtsServer100 DCOM application. To do this, follow the steps below.

1. Open the Registry Editor by typing regedit in the windows start menu. Right click and select run As Administrator.
2. Highlight Computer at the top of the list on the left of the screen.
3. Open the Edit tab at the top and select Find.
4. Paste the CLSID that was referenced in the error from the Windows System Event log.
5. Expand the key titled as the CLSID, and highlight LocalService to confirm that the DCOM application in question is MsDtsServer100 (see image below).
6. Check and/or modify the permissions assigned to the DCOM application (MsDtsServer100) by going to the windows start menu and typing DCOMCNFG, hit Enter.
7. Expand Component Services > Computers > My Computer > DCOM Config
8. Scroll down to the MsDtsServer100 application, and right-click the application to open its properties
9. Go to the Security tab, and click the Edit button under "Launch and activation permissions"
10. Edit the explicit local launch permissions by adding/modifying the account configured to run the SQL Server Agent service (see image below).

Опубліковано для:Schneider Electric Україна