SQL Server Replication over the Net

Is this possible?

[IanTurner]

Every time I specify a server for replication by IP Address I get problems in setting it up as a distributor, these are shown when you try and register a publisher - it is giving [null]Is not a registered distributor errors or is unable to find distributor properties.

Anyone have any clue? - Anyone got SQL Server replication working by IP Address?

[Spannerworks]

You don't specify which version SQL Server you are running but I have had similar problems with SQL Server 7.0 and setting up replication over the web. 2 things to try:

1. Ensure you have installed SP3 - replication doesn't work without it (!)

2. Try adding your subscriber machine IP as an alias in SQL Server Client Network Utility. This can work wonders.

[IanTurner]

Thanks for the Client Network Utility tip, that gave me the clues needed to solve the problem - I now have it up and running.