Application specific permission settings cannot include CLSID – SQL

Recently check the "event log" of each server,Want to reduce invalid information,And handling error information。This time on SQL Server,There will always be an error message like this:

應用程式特定 權限設定無法將含有 CLSID {806835AE-FD04-4870-A1E8-D65535358293} 與 APPID {EE4171E6-C37E-4D04-AF4C-8617BC7D4914} 之 COM 伺服器應用程式的 本機 啟用 權限授與來自位址 LocalHost (使用 LRPC) (在應用程式容器 無法使用 SID (無法使用) 中執行) 的使用者 NT SERVICE\SQLSERVERAGENT SID (S-1-5-80-344959196-2060754871-2302487193-2804545603-1466107430)。您可以使用元件服務系統管理工具修改此安全性權限。


First found the lecturer Hengyi wrote This Teaching,But after the actual operation,Slightly different from my condition,My own System and Administrator have problems with DCOM components (Microsoft SQL Server Integration Services) Already have full "activate" and "enable" permissions,Later tried to add in permissions “SQLSERVERAGENT”,But can't add。


Later found “Tam City Study Record” 的 This Teaching,Hit the problem,It turned out that I had to enter the full name “NT SERVICESQLSERVERAGENT”,The following are the steps:


◎ Open "Component Service",In "DCOM Settings",Switch to “Detailed materials” 'S view mode。
◎ Find the APPID in the event record one by one,I, for one,Looking for “{EE4171E6-C37E-4D04-AF4C-8617BC7D4914}“。
◎ Finally, you can find the corresponding component "Microsoft SQL Server Integration Services 12.0"。


◎ Right click on the component-"Content",Switch to the "Security" page。

◎ Click on the item "Activation and Activation Permission" “edit”。


◎ Click "Add",Ready to add the role of SQLSERVERAGENT。




◎ Turn on "Local Start"、The permission of "Local Activation" is changed to “allow” To。



One Response

  1. Application specific permission settings cannot include CLSID – AD | Old Sen Chang Tan Says |

    […] Wrote an article last week, "Application specific permission settings cannot contain CLSID-SQL",At that time, I saw it in the system event record on SQL Server,The permissions in question are in the role of SQLSERVERAGENT,There is no problem with the permissions of the server itself (SYSTEM 及 Administrator)。I saw the same message on the AD server today,This time, the server itself has insufficient permissions,Therefore, multiple steps are required to retrieve the permissions from regedit。 […]

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.