Team Foundation Server 2010 Advanced Configuration: Failed to load Msxmlsql.dll

Question

Hi,

I'm trying to configure Team Foundation Server 2010 but i get an error during database configuration step.

I'm using: Windows Server 2008 R2 Enterpise, SQL Server 2008 R2, Sharepoint 2010.

I performed the configuration from the Administation Console of Team Foundation choosing "Advanced".

I found some similar topics on forums about this problem, although they are related on older versions os SQL Server I tried to perform the solution proposed: I gave complete control to the user Everyone on the file msxmlsql.dll that is in "C:\Program Files\Microsoft SQL Server\100\Shared", i also copied the DLL in "C:\Program Files\Microsoft SQL Server\90\Shared" and "C:\Program Files\Microsoft SQL Server\80\Shared" but still doesn't work.

 

Could someone help me?

Thanks

Mauro

 

The error (Italian):

TF255356: errore durante la configurazione dei database Team Foundation: Errore durante l'esecuzione del passaggio del servizio Register Configuration Database per il componente Install durante Install: Failed to load Msxmlsql.dll.
Could not find prepared statement with handle 0.
sp_xml_removedocument: The value supplied for parameter number 1 is invalid.
Error 500004, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.
The statement has been terminated.. Per ulteriori informazioni, vedere il log di configurazione.

 

The Detail (Italian):

Errore durante l'esecuzione del passaggio del servizio Register Configuration Database per il componente Install durante Install: Failed to load Msxmlsql.dll.
Could not find prepared statement with handle 0.
sp_xml_removedocument: The value supplied for parameter number 1 is invalid.
Error 500004, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.
The statement has been terminated.

 

I can post the entire log file if you need.

Answer 1

The log file is in http://www.mediafire.com/?6p1dx1z9gyb23rc

Answer 2

Looks like a SQL Server issue to me. Try executing the following statement from the SQL Server Management Studio. If it reports an error, you should post to SQL Server forum.

Regards,
--Vladimir
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

Answer 3

Hi, thank you for the reply, actually it is a SQL Server problem.

sp_xml_preparedocument and sp_xml_removedocument cannot load msxmlsql.dll that is necessary to work with xml documents.

I found some other posts that explain how to solve this problem in older SQL Server version. It is strange that I have the same error in 2008 R2, moreover the solution proposed did not works in my case.

What I did is just downgrade to Windows Server 2008 SP2 and SQL Server 2008 with SP1 and everithing is ok !

 

thank you again

 

Mauro

Answer 4

Hi,

I bumped into the same problem with my TFS2010 Installation.

Initially I had MS SQL 2008 Express with Advanced Features running on my server and I managed to install TFS2010 without SharePoint support.

Having tested the system I decided to add WSS to use SharePoint services in our team. I installed MS SQL Server 2008 R2 Developer Edition as a second named instance on the same server and tried to remove and re-install TFS2010 with WSS and Reporting Services support (the latter required a non-express SQL Server instancance as well).

Strangely enough I could not re-install the TFS2010 from the same installation as I used before to install TFS2010 for the first time. I always get the same error message as quoted in the very first message of the thread.

Being a certified MCITP DBA for MS SQL Server 2008 I managed to localize the problem using a script similar to what you have publishered here. Indeed, none of the stored procedures which depend on MS XML Library (sp_xml_*) can be run and there is always the same error message:

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

Strangely enough this problem now occurs on both server installation, whereas I did not see this problem during the very first installation on SQL Express.

Needless to say that the DLL is here in both installations in the folder "Shared".

Compared to the other solutions I found in Internet (like http://support.microsoft.com/kb/929668 ) I run MS SQL Server 2008 and 2008 R2 on Windows Server 2008 SP2 x64, so I can not use the solutions where since they all target Server 2003 or Windows 2000.

Do you have any other ideas what I could try?

Regards,

Alexander.

---

Never stop asking!

Answer 5

We had the same issue but the "downgrade" solution did not help.

Situation:

1. SQL Server 2008 Express with Advanced Services was installed on a Windows 2008 box.
2. TFS 2010 installed, everything works fine
3. SQL Server 2008 R2 Developer installed -> TFS 2010 and WSUS stopps working with the same message as above

Downgrade vom SQL Server 2008 R2 to SQL Server 2008 did not help. Nor did reinstall of the Express instance.

Solution:

I suspected the Program Files\Microsoft SQL Server\100\Shared\msxmlsql.dll having been upgraded by the R2-installation to cause the problems. So I made a backup of it and replaced it from the msxmlsql.dll from the 90\Shared folder. It immediately worked, without  registering or anything.

Hope this helps others.

Answer 6

Hi Tom,

thanks for that message. I also run into that, but I only have one such file here and it doesn't work.

Please, can you post the 'File Version' of the two files to make all clear, thanks. There were also msxmlsql.rll files, did you swapped this files too?

Thanks a lot

 

---

Gerhard

Answer 7

Hi Tom,

I try FileVersion 2009.100.1600.1 and 2005.090.4035.00 both versions failed.

With best regards

---

Gerhard

Answer 8

Hi Tom,

I tried 2005.090.4035.00, 2007.100.1600.22 and the original 2009.100.1600.1, nothing of that worked out. After changing the file I always reboot the system.

With best regards

---

Gerhard

Answer 9

Hi Tom,

sorry, but changing the files didn't work out here.

I decide now, to setup a virtual server with Hyper-V and install Windows Server 2008 R2 without any additional role, only have to enable the .net 3.5.1 feature and install TFS 'Standard'. This works fine and now, nobody is allowed to touch that 'machine'. Hope the TFS would work for more than 3 month without failure.

As I stated, TFS seems to be instable as nitroglycerin.

Not so nice, because the features TFS offers were great, but without a working instance, the best feature set is just useless.

With best regards

---

Gerhard

Answer 10

Hi folks,

After some digging it was discovered that the reason why SQL server is failed to load msxmlsql.dll is that it is trying to load dll from server's root directory C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL. The solution which helped me without downgrading or reinstalling anything is simple copying the following files:

"C:\Program Files\Microsoft SQL Server\100\Shared\msxmlsql.dll" to the folder "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn"

"C:\Program Files\Microsoft SQL Server\100\Shared\Resources\1033\msxmlsql.rll" to the folder "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\Resources\1033"

(both files weren't existed in the destination)

This perfectly worked for me.

---

b.r., ap3rus

Answer 11

Thanks for your solution Vlad, It really helps me ;)