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?

We've tried both.

Here are some more things we've tried:

- Modified local security policies
- Modified Domain GP for admin accounts
- Used a domain...

Thank you, yes the Import and Export Wizard does appear to be an option in Web Edition. We will see if it could provide an alternative solution.

Does anyone...

Yes I think you are right, we'll have to keep an eye on it! Many thanks for your assistance.

Thank you, yes you are right, and we do have some error handling in place already. The actual script is below - can you see any way in which we...

/S : Copy Subfolders.

/MIR : MIRror a directory tree - equivalent to /PURGE plus all subfolders (/E)

Incredibly, it appeared to be a security issue on a...

I have found the solution:

https://msdn.microsoft.com/en-us/library/ms190078.aspx

Options | Query Results |SQL Server |Results to Grid Page | Retain CR/LF on copy or save

Open a new query window and the carriage...