INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Team Foundation Server 2010 Advanced Configuration: Failed to load Msx

Team Foundation Server 2010 Advanced Configuration: Failed to load Msx

Team Foundation Server 2010 Advanced Configuration: Failed to load Msx

(OP)
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 attach the log file.

RE: Team Foundation Server 2010 Advanced Configuration: Failed to load Msx

(OP)
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 !


Mauro

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close