Sql Server replication requires the actual server name to make a connection to the server (Replication to Azure VM Issue)


When I try to create a new subscription for my Azure VM default database server (2008 R2), I have run into this error:
“Sql Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address or any other alternate name are not supported. specify the actual server name”

The connection I used is the DNS name for the server:
myVM.cloudapp.net,57500
It seems the replication does not like this way even though you can connect to the database server with no problem through SSMS.
There is no server name change involved either.
The solution I found from a stackoverflow thread: .

I have included the solution here provided by eLVik:
Steps:

Read the error message and remember SERVERNAME which is in quotes.
Run Sql Server Configuration Manager on publisher/distributor side;
Expand Sql Native 10.0 Configuration\Aliases node;
Create new alias which name exactly SERVERNAME from 1. It is should be a NetBIOS machine name or NetBIOS\instance_name for named instances.
Specify another options for alias (port, server and protocol).
Repeat 4 and 5 for 32bit native client.

Test. Run Management Studio on the same machine and try connect to the server (specify alias as server name).

Repeat 2 – 7 for all client machines where Management Studio will be used for replication setup.

For my 64-bit machine, I need to create new alias for both 32-bit and 64-bit (Sql Native 10.0) as described above.
In my case to connect my database at Azure VM:

Alias Name: myVM
Port No: 57500
Protocol: TCP/IP
Server: myVM.cloudapp.net

Click Apply button when you are ready.

Advertisements

One Comment on “Sql Server replication requires the actual server name to make a connection to the server (Replication to Azure VM Issue)”

  1. Gefferson Rodrigo Librelato says:

    You are the guy! I have the same problem with Arvixe.com and this solution works very well


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s