Failed to load Msxmlsql.dll - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Failed to load Msxmlsql.dll

Author

Topic

glt101
Starting Member

28 Posts

Posted - 2008-03-11 : 10:31:46

Hi All,

Whenever I try to execute sp_xml_preparedocument I
get the following error:

Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line 1
Failed to load Msxmlsql.dll.

We have SQL Server 2005 SP2
running on
Windows Server 2003 R2 SP2

This is killing us right now.
Can anyone help?

Cheers,
Geoff

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-03-11 : 10:42:51

Did you upgrade from 2000?

Oh and have you tried googling the error? If not then how can you say this is killing you right now?

glt101
Starting Member

28 Posts

Posted - 2008-03-11 : 11:01:27

Hi,

No. This was a complete fresh install of SQL server 2005.
I saw the MS KB article about the MSxmlsql.dll getting
deleted from C:\Program Files\Microsoft SQL Server\80\Shared
during the upgrade, but I think that causes the problem on
SQL Server 2000 not 2005.
http://support.microsoft.com/kb/929668
So the solution proposed there is not applicable in this case...
I think.

C:\Program Files\Microsoft SQL Server\80\Shared
is indeed missing, but
C:\Program Files\Microsoft SQL Server\90\Shared\msxmlsql.dll
is present. This is what I would expect.

Cheers,
Geoff

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-03-11 : 11:47:26

Have you read this KB article?

http://support.microsoft.com/kb/941105

glt101
Starting Member

28 Posts

Posted - 2008-03-11 : 11:52:00

Hi,

Yes. I am planning a service restart at 12:30pm (in
about 40 minutes). We have another dll (an xp) are
that is working fine, so I have my doubts that it's
this problem. But we'll see...

Cheers,
Geoff

glt101
Starting Member

28 Posts

Posted - 2008-03-11 : 12:48:49

Hi All,
The restart fixed the problem.

http://support.microsoft.com/kb/941105
is the culpret it seems. Anyone know if
the hotfix actually works?

Cheers,
Geoff

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-03-11 : 12:52:14

I would guess it does, not tried it though.

mclavreuil
Starting Member

1 Post

Posted - 2011-06-16 : 12:30:20

I had a similar problem but with an x64 SQL Server 2008 R2 Developer edition.
I post the workaround here for those who may be in the same situation.

Some other product installed an x64 SQL Server 2008 Express beside my 2008R2Dev instance and all xml procedure stop to work with the same message quoted upper.
The workaround. I copied two files from the installation DVD to my disk.

Stop the SQL instance

From the DVD : \1033_ENU_LP\x64\Setup\sql_engine_core_shared_loc_msi\PFiles\SqlServr\100\Shared\Res\1033\msxmlsql.rll
To : \Program Files\Microsoft SQL Server\100\Shared\Resources\1033

From the DVD: \x64\Setup\sql_engine_core_shared_msi\PFiles\SqlServr\100\Shared\msxmlsql.ddl
To : \Program Files\Microsoft SQL Server\100\Shared

Start the instance.

Test with a statement like this one:
DECLARE @docHandle INT
DECLARE @error INT
EXEC sp_xml_preparedocument @docHandle OUTPUT, N'<root><child/></root>'
SET @error =@@ERROR
IF @error =0
BEGIN
EXEC sp_xml_removedocument @docHandle
END

And... OK : Command(s) completed successfully.

Hope it will help

Martin CLAVREUIL

glt101
Starting Member

28 Posts

Posted - 2011-06-16 : 12:49:04

Hi Martin,
We actually replaced that server since then.
But nice to know your file replacement worked.
Cheers,
Geoff

quote:
Originally posted by mclavreuil

I had a similar problem but with an x64 SQL Server 2008 R2 Developer edition.
I post the workaround here for those who may be in the same situation.

Some other product installed an x64 SQL Server 2008 Express beside my 2008R2Dev instance and all xml procedure stop to work with the same message quoted upper.
The workaround. I copied two files from the installation DVD to my disk.

Stop the SQL instance

From the DVD : \1033_ENU_LP\x64\Setup\sql_engine_core_shared_loc_msi\PFiles\SqlServr\100\Shared\Res\1033\msxmlsql.rll
To : \Program Files\Microsoft SQL Server\100\Shared\Resources\1033

From the DVD: \x64\Setup\sql_engine_core_shared_msi\PFiles\SqlServr\100\Shared\msxmlsql.ddl
To : \Program Files\Microsoft SQL Server\100\Shared

Start the instance.

Test with a statement like this one:
DECLARE @docHandle INT
DECLARE @error INT
EXEC sp_xml_preparedocument @docHandle OUTPUT, N'<root><child/></root>'
SET @error =@@ERROR
IF @error =0
BEGIN
EXEC sp_xml_removedocument @docHandle
END

And... OK : Command(s) completed successfully.

Hope it will help

Martin CLAVREUIL

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources