0

I buy a cloud vps on vsp.ag , which is ubuntu os and I install sql server using this .
I can remotely connect from my local PC using IP address of VPS . But I can't configure the distribution.

It said

SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name, 

'v3149'. (Replication.Utilities)

What I want to do is synchronization my local database and the database on vps using merge replication .
How can I fix it ?

  • Replication requires the actual server/instance name of the server. That is, you cannot connect to a DNS alias or IP. Try connecting to the server name listed when you query SELECT @@servername. – AMtwo Jan 10 '17 at 4:13
  • Yes , when I use the server name , it said A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. – zey Jan 10 '17 at 4:17
  • 1
    Are you sure Merge Replication is supported with Linux edition? – ErikEJ Jan 10 '17 at 7:04
  • @ErikEJ I believe you are correct. Replication is not supported yet according to the current release notes: docs.microsoft.com/en-us/sql/linux/… – Brandon Williams Jan 11 '17 at 18:23
2

According to Release notes for SQL Server vNext on Linux, under the section Unsupported features and services, Replication is not currently supported.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.