אם גם לכם יש SQL SERVER 2012
והשגיאה הזו:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{FDC3723D-1588-4BA3-92D4-42C430735D7D}
and APPID
{83B33982-693D-4824-B42E-7196AE61BB05}
to the user NT SERVICE\SQLSERVERAGENT SID (S-1-5-80-344959196-2060754871-2302487193-2804545603-1466107430) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool.
מציפה את ה Event Viewer שלכם
זה אומר שאתם צריכים לתת ליוזר שמריץ את ה SQL SERVER AGENT הרשאה להפעלה של ה COM OBJECT של SSIS
הפתרון:
1) Run Dcomcnfg.exe
2) Expand Component Service -> My Computer ->DCOM Config
3) Locate “Microsoft SQL Server Integration Services 11.0”
4) Right click and select “Properties”
5) Select “Security” tab
6) In Launch and Activate Permissions, click on “Edit”
7) Grant “Local Launch”, “Local Activation” permissions for SQL Agent Service account
8) Restart all Data collectors, Check Windows System Event log for any DCOM errors that you were seeing before.
