x

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, 2011 at 03:47 AM in Default

Bhuvans gravatar image

Bhuvans
220 19 19 21

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

2 answers: sort newest
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, 2011 at 09:25 PM

Bhuvans gravatar image

Bhuvans
220 19 19 21

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

answered Jun 10, 2011 at 03:57 AM

Kev Riley gravatar image

Kev Riley ♦♦
53k 47 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?

and

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, 2011 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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1840
x726
x305

asked: Jun 10, 2011 at 03:47 AM

Seen: 6134 times

Last Updated: Jun 10, 2011 at 03:47 AM