SQL server Replication requires actual server name?

I configured a public ip as (69.xxx.xxx.xxx) to my SQL server port in server. by using that public port i am trying to create a publication but i am getting the error as abelow

SQL server name requires actual server name to make a replication,Connections through server alias are not supported..

My distributor and publisher are same?

My Querires

  1. Can we configure replication by using Public IP of Sql server port?
  2. How to do this?
  3. whats the mistake i am doing?
Regards Bhuvan
more ▼

asked Jun 10 '11 at 03:47 AM in Default

Bhuvans gravatar image

220 17 19 21

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
Yeah finally i got it... If i use public IP, I cant do replication using SQL Replication Wizard in SQL 2008 R2, because before launching wizard it checks whether server name is equal to @@servername. but i am able to create publication, subscription using RMO.
more ▼

answered Jun 13 '11 at 09:25 PM

Bhuvans gravatar image

220 17 19 21

(comments are locked)
10|1200 characters needed characters left
more ▼

answered Jun 10 '11 at 03:57 AM

Kev Riley gravatar image

Kev Riley ♦♦
50.7k 43 49 76

thanks Kev But i had a doubt 1. Should i create alias at server side or client side? 2. If i create an alias at server(publisher) side as

alias Name : -69.xxx.xxx.xxx Port : -1433 Protocol : -TCP Server : -ServerName(Bhuvan1)

Is this right?


I am adding in host like this in server C:\Windows\System32\Drivers

Opening hosts file in notepad and adding ports as 69.xxx.xxx.xxx Server name

is it right
Jun 10 '11 at 04:05 AM Bhuvans
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 10 '11 at 03:47 AM

Seen: 5577 times

Last Updated: Jun 10 '11 at 03:47 AM