How exactly are you connecting to SQL on the different servers?

Yes, SQL can be configured to listed on multiple IPs, ports and protocols.

Have you tried just reinstalling the Distributed Replay Controller by itself?

Install Distributed Replay (Setup)

What happens if you use T-SQL commands to do it?

I am not an expert with column-level encryption, but I think you are going to have to import the certificate you created on the primary instance over to your secondary...

The only things I think you may need to watch out for are:

- Instance names: You can only have one default instance on a server. It might be better to...

Is this on a cluster? When you say "server property" what are you selecting exactly?

@@servername will give the local machine name, except in a failover cluster, where it will give...

You may want to check out this article on schema changes in replicated databases:

Schema Changes on Publication Databases

You can plan to have your table changes replicated to your subscribers. The...

Have you tried the following:

MSSQLSERVER_233

Is it a third-party app database or an in-house app that you have reach-back to the devs? I ask because just because I would think that just because you do...

If you access SQL on the primary and secondary instances through SSMS and right-click on each instance and go to Reports > Standard Reports > Transaction Log Shipping Status, what...

Is this path it is trying to get the trans log backup from valid? It does not seem correct. Specifically where the server name is listed...

Have you looked at what MS12-027 is? Microsoft shows affected products on their vulnerabilities at the bottom of the vulnerability page.

MS12-027: Vulnerability in MSCOMCTL.OCX could allow Remote Code Execution: April...

I wonder if it could be an authentication issue? Is reporting services using Kerberos or NTLM? If it is NTLM it could be a double-hop issue.

You could try the following:

- Take a full backup of the database close to the time you want to setup log shipping

- Move the backup to the secondary site

- Restore...

Like Jeff I use xp_cmdshell with PowerShell to query the Win32_Volume WMI class. You wouldn't need xp_cmdshell or PowerShell at all if SQL could issue WQL command, but alas. This...