SQL server getting Event ID 10016 every hour
We are getting below error message on our SQL server with OS WS2012 every hour.
"The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
to the user NT SERVICE\SQLAgent$IBSQL2012 SID (S-1-5-80-485265429-2350460967-4062759752-2586802043-2488535659) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool."
I already went through some threats and read other post on internet, but under Component Services, Security tab of the particular service related to this message (based on its APPID) I can see that SYSTEM is already added and it has Local launch and Local Activation permissions granted.
Why are we still getting this issue, is because instead of local permissions we should grant Remote ".....from address LocalHost (Using LRPC) ..."?
Find the sql agent service in question
open it's properties
go to the logon tab
copy everything in the "This Account" box.
find the com+ application (you can also just right click "My computer" here and change the default for the whole system if you're lazy)
Go to properties
Go to COM security tab
Click edit default button in the "launch and Activation" permissions area
Change from your domain to your local server.
Paste the info you copied from the service logon tab above into box.
Click "check names"
It should change it to the name you need on it's own.