The server could not load DCOM

Posted on 2006-05-02
Last Modified: 2008-01-09
Hi everyone.
I'm having a problem in a SQL Server 2000, SP4.
Here is the explanation:

I'm trying to run dbcc checktable ('myTable') in a query analizer window and i'm getting the following error:

ERROR 7404: The server could not load DCOM.

I'll appreciate any help you can give me.
This is very important for the performance of my system. So, i'm a in a little hurry.
Thank you very much!!!

Leandro Nuñez.

Question by:juands
    LVL 9

    Assisted Solution

    i tried google, and not much came up. here's one you might want to check

    Google searches range from DCOM being corrupted, privacy software causing issues, network problems and the DTS package having invalid transformations causing the problem.

    are you on SP4?
    LVL 9

    Expert Comment

    yes you are on SP4 sorry.
    LVL 4

    Accepted Solution

    I haven't ever seen the DCOM error but similar "unable to determine if the owner...." errors can be due to issues with
    the owner of the job. Try changing it to a sysadmin login. You may also want to check your SQL Server and Agent error
    logs - for any additional information. Other issues can be due to the service account that SQL Server Agent runs

    Chetan Sachdeva
    LVL 1

    Author Comment

    i've tried changing the owner to sysadmin to all of the possible ways. I thought like you. But nothing.
    Something to open your mouht: there are no errors in the server or Agent logs.
    I've tried looking for them in Windows Event Viewer.... nothing at all.

    Thenks a lot for your quick answers.

    Leandro Nuñez.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now