asked
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
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.
I would suggest reviewing these links to similar issues - - - The answer seems to lie in a combination of aliases and host file entries. The go and give this item a kick on Connect
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
