Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

sql server replicatoin requires actual server name to make a connection to the server Expand / Collapse
Author
Message
Posted Saturday, October 27, 2007 4:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Saturday, October 27, 2007 7:25 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-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
Posted Saturday, November 10, 2007 3:42 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Monday, November 12, 2007 9:08 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 10:18 AM
Points: 2,153, Visits: 645
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
Posted Monday, November 12, 2007 9:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, November 12, 2007 9:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 10:18 AM
Points: 2,153, Visits: 645
Hi,

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


Thank you,
Phillip Cox
Post #421119
Posted Monday, November 12, 2007 10:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:24 AM
Points: 12,904, Visits: 31,976
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
Posted Wednesday, November 21, 2007 7:14 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:08 PM
Points: 1,414, Visits: 4,540
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
Posted Friday, November 23, 2007 2:06 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Monday, June 28, 2010 9:05 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 28, 2010 9:05 PM
Points: 31, 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 »

Add to briefcase 12»»

Permissions Expand / Collapse