Home
%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

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!