SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


server could not load DCOM


server could not load DCOM

Author
Message
StefanJ
StefanJ
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1687 Visits: 11
I have installed SQL Server developer on my home pc running Windows XP Professional.

I get the following error message in job history:

The job failed. Unable to determine if the owner (ANTEC\Stefan) of job test has server access (reason: The server could not load DCOM. [SQLSTATE 42000] (Error 7404))



lucky-80472
lucky-80472
SSCarpal Tunnel
SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)

Group: General Forum Members
Points: 4047 Visits: 842

Hello Stefan,

Do you find any information in SQL Server Logs or Event Viewer?

What does the stored procedure do?

If you can provide more information, then we can go ahead investigating it in the right direction.

Thanks and have a nice day!!!




Lucky
StefanJ
StefanJ
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1687 Visits: 11
This is a failing job, not a stored procedure. The error message in the Event Viewer is:

Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 30/01/2006
Time: 16:20:39
User: N/A
Computer: ANTEC
Description:
SQL Server Scheduled Job 'test2' (0x33EE095F4BC451479C4903CDEE9B0D74) - Status: Failed - Invoked on: 2006-01-30 16:20:39 - Message: The job failed. Unable to determine if the owner (ANTEC\Stefan) of job test2 has server access (reason: The server could not load DCOM. [SQLSTATE 42000] (Error 7404)).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



StefanJ
StefanJ
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1687 Visits: 11
I also get a similar message when trying to create a new database in Enterprise manager:

Dialogue box:

Microsoft SQL-DMO (ODBC SQL State:42000)
Error 7404: The server could not load DCOM.

However after clicking OK on the dialogue box I can still create a database. I can also create a database from QA without any error.



lucky-80472
lucky-80472
SSCarpal Tunnel
SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)

Group: General Forum Members
Points: 4047 Visits: 842

Hello Stefan,

Can you check this information in Books Online -> Installing SQL-DMO

Check whether the said files are existing in the default location.

Thanks and have a nice day!!!




Lucky
Peter Tillotson
Peter Tillotson
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1565 Visits: 81
Make sure that your windows firewall is disabled and that the services needed for DCom to work are running. I am not absolutely sure what the services are but the Remote Procedure Call (RPC) service and the COM+ Event system service should be running.



P Marsh
P Marsh
SSC-Enthusiastic
SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)

Group: General Forum Members
Points: 102 Visits: 1
I've got exactly the same problem and I just can't find out what the issue is. If I try and create a database via Management Studio I get the above error. If I use TSQL it creates without any problems. Also if I connect to another SQL Server machine I can happily use Management Studio! So it seems it's having trouble communicating to the local server!!? I played around with every DCOM setting I can see, the firewalls been up and down and that doesn't seem to help. I'm totally stumped. HELP!
Peter Tillotson
Peter Tillotson
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1565 Visits: 81

DCOM allows you to start com+ (activex) components executing on another pc or server, but you need to have the correct permission and it needs various services to be running on that server.

When you create a database in TSQL the command is actually executing on the server so it isn't using DCOM.

When you run a command in management studio it needs to start a com+ component on the remote (or local) server in order to do what it needs, but for some reason the com+ component won't start. Check the event log for error messages. Check the services that are running on the server you can link to (the com based ones and the remote connection ones).

The problem can also be security. You need to have the (windows) permission to start dcom components.

For interest, if you want to look at the authentication required for specific dcom components: on the server type in dcomcnfg (in START/run), then double click on component services and then Computers, then click on My computer and Dcom config. Enter yes to any messages that come up. Right click on the dcom component you are interested in and select properties.

Sorry, I don't know what dcom component management studio uses on the server.

Hope this points you in the right direction. i.e. look at the differences in the services and permissions you have to the problem server and the one that is OK.

Peter





P Marsh
P Marsh
SSC-Enthusiastic
SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)

Group: General Forum Members
Points: 102 Visits: 1

Peter, thanks the message but WHICH component? In my case I can't create databases on the same server as tools but it WILL create databases on a remote server. I've tried enababling all sorts of things in DCOM, default/launch etc. One of the things I'm considering is that I don't run on a Domain (when it's local) and some of the DCOM stuff I've found seems to suggest that you need a domain user. Perhaps that's the issue, but I've no idea how to solve it since I don't have a domain controller on my own network. The other avenue is the COM SQLDOM objects, but I would imagine they'd be used to talk to a remote server.


jimmytrue
jimmytrue
SSC-Enthusiastic
SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)

Group: General Forum Members
Points: 114 Visits: 237

I am having a similar problem. I was trying to install a new piece of software (Journeyx Timesheet), and after the installation and upon rebooting, the following entries appear in my SQL Server Log:

Failed to Initialize COM (CoInitializeEx returned 80010106)
Heterogeneous Queries and Remote RPC will be disabled.
Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.

And at this point, certain functions have stopped working. For example,

SELECT * FROM ::fn_helpcollations()

returns the following error message:

Server: Msg 7404, Level 16, State 2, Procedure fn_helpcollations, Line 9
The server could not load DCOM.

Likewise, attempting to add a new database prompts with "The server could not load DCOM" (which I suspect is because the New Database dialog box also displays the list of Collations in a drop-down box).

Prior logs do not show this error, and uninstalling the software and rebooting has not cleared up the problem.

Anyone have any ideas?


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search