Could not connect Azure server when configure On-Premises Subscriber

Question

Hi Friends,

I am trying to set up Replication from On-premises to Azure SQL Database. In On-premises DB, I created the publication but when I tried to add a subscription, I could not connect to Azure Server which throws the following error.

When I used the server name "tcp:fciweb.database.windows.net,1433" to log in (Object Explorer), it worked fine. But when I used the same server name "tcp:fciweb.database.windows.net,1433" to create the subscription, which asked to mention the server name "fciweb" only.

Please help me to resolve this server name issue.

Thanks in Advance.

James

Answer 1

I found https://learn.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database?view=azuresql and it says:

Publishing to any Azure SQL Database from a SQL Server database is supported by the following versions of SQL Server: SQL Server 2016 and greater SQL Server 2014 RTM CU10 (12.0.4427.24) or SP1 CU3 (12.0.2556.4) SQL Server 2012 SP2 CU8 (11.0.5634.1) or SP3 (11.0.6020.0)

And you are SQL 2008 R2. Time to upgrade, I guess!

Answer 2

Can you try to connect without the port# 1433 ?

It worked for me without adding the port number