A
AMishra24
Guest
Hello
I have installed sql server 2016 standard edition on windows server 2012R2 and changed the "Sql server and sql agent services" logon account and assigned the account with administrator rights.
I have created the database backup jobs for full and transaction log backup.
Now we are getting the error event id 10016 with the database backup job being executed every time.
Can this error create more problem with database server or other services?
Can we ignore this error as our database backups being created and i also restored the backups on another backup server without any error.
Log Name: System
Source: Microsoft-Windows-DistributedCOM
Date: 10/01/2019 02:30:06
Event ID: 10016
Task Category: None
Level: Error
Keywords: Classic
User: DBSERVER\SQLAcc
Computer: DBserver
Description:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{2DC39BD2-9CFF-405D-A2FE-D246C976278C}
and APPID
{DB336D8E-32E5-42B9-B14B-58AAA87CEB06}
to the user DBSERVER\SQLAcc SID (S-1-5-21-2515158775-1876614093-3327378803-1005) 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.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-Windows-DistributedCOM" Guid="{1B562E86-B7AA-4131-BADC-B6F3A001407E}" EventSourceName="DCOM" />
<EventID Qualifiers="0">10016</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x8080000000000000</Keywords>
<TimeCreated SystemTime="2019-01-10T02:30:06.476764900Z" />
<EventRecordID>44196</EventRecordID>
<Correlation />
<Execution ProcessID="2864" ThreadID="15232" />
<Channel>System</Channel>
<Computer>DBserver</Computer>
<Security UserID="S-1-5-21-2515158775-1876614093-3327378803-1005" />
</System>
<EventData>
<Data Name="param1">application-specific</Data>
<Data Name="param2">Local</Data>
<Data Name="param3">Activation</Data>
<Data Name="param4">{2DC39BD2-9CFF-405D-A2FE-D246C976278C}</Data>
<Data Name="param5">{DB336D8E-32E5-42B9-B14B-58AAA87CEB06}</Data>
<Data Name="param6">DBSERVER</Data>
<Data Name="param7">SQLAcc</Data>
<Data Name="param8">S-1-5-21-2515158775-1876614093-3327378803-1005</Data>
<Data Name="param9">LocalHost (Using LRPC)</Data>
<Data Name="param10">Unavailable</Data>
<Data Name="param11">Unavailable</Data>
</EventData>
</Event>
Regards
Ashutosh
Continue reading...
I have installed sql server 2016 standard edition on windows server 2012R2 and changed the "Sql server and sql agent services" logon account and assigned the account with administrator rights.
I have created the database backup jobs for full and transaction log backup.
Now we are getting the error event id 10016 with the database backup job being executed every time.
Can this error create more problem with database server or other services?
Can we ignore this error as our database backups being created and i also restored the backups on another backup server without any error.
Log Name: System
Source: Microsoft-Windows-DistributedCOM
Date: 10/01/2019 02:30:06
Event ID: 10016
Task Category: None
Level: Error
Keywords: Classic
User: DBSERVER\SQLAcc
Computer: DBserver
Description:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{2DC39BD2-9CFF-405D-A2FE-D246C976278C}
and APPID
{DB336D8E-32E5-42B9-B14B-58AAA87CEB06}
to the user DBSERVER\SQLAcc SID (S-1-5-21-2515158775-1876614093-3327378803-1005) 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.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-Windows-DistributedCOM" Guid="{1B562E86-B7AA-4131-BADC-B6F3A001407E}" EventSourceName="DCOM" />
<EventID Qualifiers="0">10016</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x8080000000000000</Keywords>
<TimeCreated SystemTime="2019-01-10T02:30:06.476764900Z" />
<EventRecordID>44196</EventRecordID>
<Correlation />
<Execution ProcessID="2864" ThreadID="15232" />
<Channel>System</Channel>
<Computer>DBserver</Computer>
<Security UserID="S-1-5-21-2515158775-1876614093-3327378803-1005" />
</System>
<EventData>
<Data Name="param1">application-specific</Data>
<Data Name="param2">Local</Data>
<Data Name="param3">Activation</Data>
<Data Name="param4">{2DC39BD2-9CFF-405D-A2FE-D246C976278C}</Data>
<Data Name="param5">{DB336D8E-32E5-42B9-B14B-58AAA87CEB06}</Data>
<Data Name="param6">DBSERVER</Data>
<Data Name="param7">SQLAcc</Data>
<Data Name="param8">S-1-5-21-2515158775-1876614093-3327378803-1005</Data>
<Data Name="param9">LocalHost (Using LRPC)</Data>
<Data Name="param10">Unavailable</Data>
<Data Name="param11">Unavailable</Data>
</EventData>
</Event>
Regards
Ashutosh
Continue reading...