Question
2599 views

SQL server getting Event ID 10016 every hour

Lighthouse17 asked on

Hi guys,

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 

{FDC3723D-1588-4BA3-92D4-42C430735D7D}

 and APPID

{83B33982-693D-4824-B42E-7196AE61BB05}

 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) ..."?

Any thoughts

mcg

4 people had this question

Abuse history


The answered status icon Answer
JasonVDub replied on

open services

Find the sql agent service in question

open it's properties

go to the logon tab

copy everything in the "This Account" box.

open com+

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

Click Add

Click "location'

Change from your domain to your local server.

Click ok

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.

click ok.

done.

3 people found this helpful

Abuse history


The answered status icon Answer
A. User replied on
Ask in the SQL Server forums:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver
2 people found this helpful

Abuse history


progress