Thank you all for your replies, apologies but it does appear that some of our obfuscation has resulted in the above script not accurately reproducing the same issue. In addition,...

Hi Sue, thanks very much for your advice!

TCP port 1434 was being blocked by our inter-data centre firewalls. The issue has now been fixed. Thanks to all for your help!

Hi Sue, thank you for the clarification regarding the Browser Service, that's really helpful. I modified the error message to add <namedinstance> for completeness, apologies if it was misleading. Yes...

It appears at present that TCP port 1434 is being blocked by our inter-data centre firewalls. This protocol/port has already been configured in the local firewalls. We are just waiting...

Hi Sue, yes I can confirm that this had already been enabled.
Configuration option 'remote admin connections' changed from 1 to 1. Run the RECONFIGURE statement to install.
Unfortunately...

Further information:
It turns out these errors only occur when attempting to connect to a given instance via the DAC from a different database server on the same network. We...

Apologies for the delayed response. Not wanting to resort to CDOC, we found a workaround as follows:
- We split the stored procedure into two, the first with hard-coded delete...

Hi John,

Thank you for your reply, yes apologies you have spotted two typos of mine:
- The login is called something very simple (e.g. "DeleteMyRows") rather than the...

Hi Grant, thanks very much for the response. Will do!

Thank you, we have already tried, but the error still occurs.

Do you please have any other suggestions?