DCOM Error with Maintenance Plans
-
Tuesday, April 29, 2008 7:10 PM
I am receiving two occurrences of the following DCOM error every time I run a Maintenance Plan on one of my SQL Servers.
-------------------------------------------------------------------
Date 4/29/2008 10:24:06 AM
Log Windows NT (System)
Source DCOM
Category (0)
Event 3221235488
User MyDomain\MyAccount
Computer MyComputer
Message
The description for Event ID '-1073731808' in Source 'DCOM' cannot be found. The local computer may not have the necessary registry information or message DLL files to display the message, or you may not have permission to access them. The following information is part of the event:'application-specific', 'Local', 'Launch', '{ABF05265-635E-44B0-A28F-AEA45247ACA0}', 'MyDomain', 'MyAccount', 'S-1-5-21-790525478-606747145-725345543-2565'
---------------------------------------------------------------------
SQLAgent jobs not created through Maintenance Plans don’t produce the error.
I have granted ‘MyAccount’ “Launch” and “Activation” permissions through Component Services. I also think I’ve tracked the source down to MsDtsSrvrUtil.dll and registered it. The server was been rebooted. Unfortunately I’ve still getting the same two DCOM errors.
However if I run the SQLAgent under the LocalSystem account the error is not reproduced, which leads me to believe the problem is with ‘MyDomain\MyAccount’. ‘MyDomain\MyAccount’ is in the local ‘Users’ group and has rights to the reporting and backup directories through group membership.
The environment is:
SQL Server: 9.0.3228 Standard Edition
OS: Microsoft Windows Server 2003 R2 Standard Edition Service Pack 2
… and I have two other servers configured the same that do not experience the DCOM error.
I should also mention that the Maintenance Plans execute successfully. Can anyone see what I’m missing?
Thanks, Dan
Answers
-
Friday, May 02, 2008 8:08 PM
I resolved the problem. The article http://msdn.microsoft.com/en-us/library/aa337083.aspx put me on the right track.
All Replies
-
Tuesday, April 29, 2008 7:19 PMAnswerer
-
Wednesday, April 30, 2008 2:56 PMI previously tried the suggestions in that post, but they did not resolve the error.
-
Wednesday, April 30, 2008 9:04 PMAnswererSo what is the difference?
-
Wednesday, April 30, 2008 9:19 PMNotice the event ID. It doesn't look real. At least I cannot find it anywhere. I'm also trying to use a domain account although running the sqlagent under localsystem does clear the error. I've found several threads like the one you referenced, dealing with dcom errors, that discuss setting
'Componant Services' properties and registering the source dll. Unfortunately that hasn't worked for me.
Thanks for your help.
-
Friday, May 02, 2008 8:08 PM
I resolved the problem. The article http://msdn.microsoft.com/en-us/library/aa337083.aspx put me on the right track.
.png){kind=spacer}
