August 25, 2016 at 8:05 pm
Dear Helper,
I get this error message from event viewer. When I start a job using SQL Server Agent for SQL Server 2014 SP1 in Windows 2012 R2 with Windows local administrator account.
This problem may cause by I change the server name before.
eg.
Old Name:
TestingServer
- Windows local administrator account: TestingServer\administrator
New Name:
ProductionServer
-Windows local administrator account: ProductionServer\administrator
How to solve this problem? Please advise. Thank you.
Log Name: System
Source: Microsoft-Windows-DistributedCOM
Date: 26/8/2016 9:40:00
Event ID: 10016
Task Category: None
Level: Error
Keywords: Classic
User: NT SERVICE\SQLSERVERAGENT
Computer: ProductionServer
Description:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{806835AE-FD04-4870-A1E8-D65535358293}
and APPID
{EE4171E6-C37E-4D04-AF4C-8617BC7D4914}
to the user NT SERVICE\SQLSERVERAGENT SID (S-1-5-80-344959196-2060754871-2302487193-2804545603-1466107430) 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="2016-08-26T01:40:00.603574700Z" />
<EventRecordID>78567</EventRecordID>
<Correlation />
<Execution ProcessID="632" ThreadID="27796" />
<Channel>System</Channel>
<Computer>ASWGROUPERP</Computer>
<Security UserID="S-1-5-80-344959196-2060754871-2302487193-2804545603-1466107430" />
</System>
<EventData>
<Data Name="param1">application-specific</Data>
<Data Name="param2">Local</Data>
<Data Name="param3">Activation</Data>
<Data Name="param4">{806835AE-FD04-4870-A1E8-D65535358293}</Data>
<Data Name="param5">{EE4171E6-C37E-4D04-AF4C-8617BC7D4914}</Data>
<Data Name="param6">NT SERVICE</Data>
<Data Name="param7">SQLSERVERAGENT</Data>
<Data Name="param8">S-1-5-80-344959196-2060754871-2302487193-2804545603-1466107430</Data>
<Data Name="param9">LocalHost (Using LRPC)</Data>
<Data Name="param10">Unavailable</Data>
<Data Name="param11">Unavailable</Data>
</EventData>
</Event>
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply