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

Published 06-05-2019 11:31 AM 1,097 Views

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!

 

%3CLINGO-SUB%20id%3D%22lingo-sub-671914%22%20slang%3D%22en-US%22%3ELesson%20Learned%20%2390%3A%20SQL%20Server%20replication%20requires%20the%20actual%20server%20name%20to%20make%20a%20connection.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-671914%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3EToday%2C%20I%20worked%20on%20a%20service%20request%20where%20we%20got%20the%20following%20error%3A%20%22SQL%20SERVER%20replication%20requires%20the%20actual%20server%20name%20to%20make%20a%20connection%20to%20the%20server.%20Specify%20the%20actual%20server%20name%22%2C%20configuring%20the%20subscriber%20in%20a%20transactional%20replication%20in%20a%20SQL%20Server%202012%20SP3%20to%20Azure%20SQL%20Database.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3EWe%20found%20that%20SQL%20SERVER%202012%20SP3%20(11.0.6020)%20is%20not%20working%20correctly%20the%20subscriber%20configuration%20to%20Azure%20SQL%20Database%20and%20you%20need%20to%20install%20the%20Service%20Pack%204%20in%20SQL%20SERVER%202012%20(11.0.6020)%20to%20make%20it%20works.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3EEnjoy!%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-671914%22%20slang%3D%22en-US%22%3E%3CP%3EWorking%20on%20a%20service%20request%2C%20we%20found%20the%20following%20error%3A%20%22SQL%20SERVER%20replication%20requires%20the%20actual%20server%20name%20to%20make%20a%20connection%20to%20the%20server.%20Specify%20the%20actual%20server%20name%22%2C%20configuring%20the%20subscriber%20in%20a%20transactional%20replication%20in%20a%20SQL%20Server%202012%20SP3%20to%20Azure%20SQL%20Database.%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Version history
Last update:
‎Jun 05 2019 11:31 AM
Updated by: