|
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
Regards Bhuvan
(comments are locked)
|
|
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.
(comments are locked)
|
|
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 http://connect.microsoft.com/SQLServer/feedback/details/365761/sql-server-replication-requires-the-actual-server-name-to-make-a-connection-to-the-server 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:WindowsSystem32Drivers 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)
|
