I have had similar connectivity issues.

Can connect locally on the box but not by IP.

Remote connections enabled but still no luck.

In Sql Server Configuration Manager, SQL Server Network Configuration, Protocols...

Hi,

I have managed to resolve my issue.

SQL 2008 hides filename extensions by default.

Adding the .cer extension to the filename got me past the first hurle, I'll update this post with...

Why is the script called with cscript rather than wscript?

From Technet:

[font="Courier New"] Using the command-based script host (CScript.exe)

Cscript.exe is a command-line version of the Windows Script Host that provides command-line...

While some data has to be deleted, other organisations (eg NHS) have a requirement to store information for 20 years or more.

The only real solution I have found that still...

OK figured it out....

varchar(max) source data needs to be the unicode equivalent nvarchar(max)

then change the encoding on the xml from utf-8 to utf-16

repopulate the XML column.

🙂

The idea of removing the Windows dependency is appealing.