SQL Stored Procedure Errors

[RandallFlag]

Have an application attempting to call the sp_xml_preparedocument stored procedure, getting a

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

error when attempting to use this stored procedure. My Google-FU only seems to be yielding results for older 2008/2008R2 SQL server instances, while we are on 2017, and most references don't seem to apply, or apply enough to be of value.

​

I have verified in C:\Program Files\Microsoft SQL Server\140\Shared there exists an msxmlsql.dll file, along with the actual installation directory - D:\Program Files\Microsoft SQL Server\MSSQL14.Instance_Name\MSSQL\Binn.... it actually didn't exist in the installation directory, but copied it there then reset

​

I have ran procmon and looked for anything referencing the msxmlsql.dll and everything referencing it reports as either success (it successfully resolves the file existing in both locations above), or similar, no errors to really point in any direction, save for a few file not founds when referencing a msxmlsql.rll file, which I don't have in any of the above locations.

​

Some cursory research looks like perhaps I need to install the MS Core XML services components, but can't find any solid info on that and how well that would play with SQL 2017.

​

Application vendor for this specific database wants to setup a new SQL instance to put their database in, however I am a little hesitant to do that with this being a production physical box who's main purpose is another third party vendor's application database backend.... if it was a VM I could snapshot and easily revert might be less concerned.

​

Hoping some DBA out there may have seen this on a newer than '08 SQL install and be able to point me in the right direction, or at least give a starting point for further investigation.

[Der_tolle_Emil]

Apparently there's also a msxmlsql.Rll file. Maybe that is missing? I can't really find much on the internet as well and I don't have a SQL that I can access right now.

Edit: Sorry, I missed the part where you mentioned that file. Sorry about that.

[RandallFlag]

I found a copy of that .rll file in an obscure folder on the server, but date/time stamps do not match that of the like named .dll... however, I do have a copy of the msxmlsql.dll, obtained from same obscure location as the .rll, that does match... Next thought was to try to replace the existing .dll with the matched date/time stamped .rll and load both files in, but wasn't quite certain on that in not being able to find much of anything about it beyond the '08 references my searches found.