Web Development

Ask something
Discussion Locked

MSSQL 2000 internet replication

0 helpful
5 replies

by twhudson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am attempting to intergrate MSSQL 2000 replication across the internet using FTP. The Windows CE clients are working, but the offsite SQL server will not connect. The error message is that the server does not exist. I have created the Hosts file and added its IP into it. I can ping the name, but still cannot access it through the replicator.

5 replies

by joseph moore

I think you will still need TCP port 1433 open at the firewall at the remote location to be able to set up the replication like this.

hope this helps

by jmiller1

Try creating an alias for the SQL Server in the Client Network Utility. Use TCP/IP for the network library, specify the IP address for the server name, and give it an alias name. This may help you get a connection.

This discussion is closed to new replies.