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.