sql server replicatoin requires actual server name to make a connection to the server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » sql server replicatoin requires actual server...

12 posts, Page 1 of 2

1 2 »»

sql server replicatoin requires actual server name to make a connection to the server

Rate Topic

Display Mode

Topic Options

Author

Message

radhakrishnanganesh

Posted Saturday, October 27, 2007 4:37 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, November 21, 2007 9:35 AM
Points: 2, Visits: 8

I have two servers at different location

In both servers sql2005 is installed and have the same database instances

I wanted to create a replication between these two servers,

one location has static ip

iam able to connect to the remote server using the static ip, while in the replication, it is not accepting the ip, it is asking for the server name,

how do i handle this situation.???

sql server replicatoin requires actual server name to make a connection to the server, it is not accepting the alias name or ip address.

help me out

Post #415693

Deepak-405225

Posted Saturday, October 27, 2007 7:25 PM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, October 26, 2012 2:14 PM
Points: 402, Visits: 598

Can you pls check this link and see if it is helpful ?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=203340&SiteID=1

Regards
Deepak

- Deepak

Post #415751

zenprofit

Posted Saturday, November 10, 2007 3:42 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, October 19, 2011 8:00 AM
Points: 12, Visits: 80

This is exactly the same problem I am having. The referenced article did not help.

My post is here:

http://www.sqlservercentral.com/Forums/Topic420797-291-1.aspx

Please someone respond.

Post #420799

Phillip Cox

Posted Monday, November 12, 2007 9:08 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, October 12, 2012 7:55 AM
Points: 2,133, Visits: 604

Hi,

You must use server names and not ip addresses when configuring replication. You can create an alias to workaround the name problem. As you mentioned, you can use ip addresses for other operations, but replication is one feature you cannot use an ip address.

Thanks,
Phillip Cox

Post #421105

radhakrishnanganesh

Posted Monday, November 12, 2007 9:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, November 21, 2007 9:35 AM
Points: 2, Visits: 8

hi,

You cannot name your IP, by giving an alias name, sql server replication does not accept it.

*************

Procedure alias name for your IP

Edit hosts (windows\system\driver\etc - using notepad

xxx.xxx.xxx.xxx alias name

**************

this is not accepted in the replication.

Finally I have creaed a VPN between these two networks and in both the machins i have resolved the IP by a Name which is now valied between thse two machines. Once VPN is established, these two locations become a local network and now your replication works.

Thx anyways
r. ganesh

Post #421116

Phillip Cox

Posted Monday, November 12, 2007 9:40 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, October 12, 2012 7:55 AM
Points: 2,133, Visits: 604

Hi,

I was referring to SQL Server Alias, but nevertheless its worked out for you.

Thank you,
Phillip Cox

Post #421119

Lowell

Posted Monday, November 12, 2007 10:58 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 8:17 AM
Points: 11,791, Visits: 28,072

if your other SQL server has a dynamic IP, and you need a real hostname for it, look at the free services at dyndns.org.
you run a service on your remote server, and any time it's extranl ip changes, due to dialup, or DSL or CABLE changes, it updates the ip to the hostname;
for example, you might get a free account for the hostname PhillipCoxSQLServer.dydns.org
and the service just updates DYNDNS.ORG whenever the ip changes; that way your static IP server can always find PhillipCoxSQLServer.dydns.org
I use it all the time.

if the server is INTERNAL on your LAN, you do not need this service.

you can pay extra for your own domain name, and you can try it for free as explained above.

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #421144

alen teplitsky

Posted Wednesday, November 21, 2007 7:14 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, June 10, 2013 10:43 AM
Points: 1,411, Visits: 4,517

you will need to get with others in your IT department for this but here is what you can do

i'm guessing you don't have name resolution to the remote site. first you need to set up name resolution. if you can't use the current DNS zone, set up a new dummy DNS zone put in a host record for the remote server and an alias dns record (forgot the right name). you will also need to have static IP's or the right firewall policies set up for this

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]

Post #424588

zenprofit

Posted Friday, November 23, 2007 2:06 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, October 19, 2011 8:00 AM
Points: 12, Visits: 80

I will contact the IT dept and suggest they create 'dummy' DNS. Thank you. The replication is a big issue for us.

Post #425354

bbqchickenrobot

Posted Monday, June 28, 2010 9:05 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, June 28, 2010 9:05 PM
Points: 29, Visits: 9

Can't u just use the hosts file to add an entry on both ends of the repl? You wont' need to actually create/mess with DNS records for this...

Post #944359

« Prev Topic | Next Topic »

12 posts, Page 1 of 2

1 2 »»

Permissions