Lesson Learned #90: SQL Server replication requires the actual server name to make a connection.

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.

Today, I worked on a service request where we got the following error: "SQL SERVER replication requires the actual server name to make a connection to the server. Specify the actual server name", configuring the subscriber in a transactional replication in a SQL Server 2012 SP3 to Azure SQL Database. 

 

We found that SQL SERVER 2012 SP3 (11.0.6020) is not working correctly the subscriber configuration to Azure SQL Database and you need to install the Service Pack 4 in SQL SERVER 2012 (11.0.6020) to make it works. 

 

Enjoy!

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.