New SQL Server registration from internet

Hello,
I have two SQL 2K server, both are running fine with public IP address.
i.e.
Server #1: 100.100.100.101
Server #2: 200.200.200.202
I use SQL Server #1 Client Network Utility to create an Alias i.e. SQL2.
The alias has the ip 200.200.200.202 and port 1433
Then I use SQL Server #1 Enterprise Manager to register SQL2 with SQL Server
authentication. (login name: sa and password)
Then I got the following error message:
"SQL2 - SQL Server does not exist or access denied. Connection(Connect("
Thanks
Try to see if connectivity is possible at all - ie register the IP address
in enterprise manager and see it this works on its own.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||No,
Can not register IP address or Alias.
Thanks
"Paul Ibison" wrote:

> Try to see if connectivity is possible at all - ie register the IP address
> in enterprise manager and see it this works on its own.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||But I can ping each other.
Thanks
"Paul Ibison" wrote:

> Try to see if connectivity is possible at all - ie register the IP address
> in enterprise manager and see it this works on its own.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Check on the server whose IP address is being registered, using the server
network utility, to confirm that port 1433 is being used.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hello,
There is no IP address is being registered.
Yes, the port is 1433
Thanks
"Paul Ibison" wrote:

> Check on the server whose IP address is being registered, using the server
> network utility, to confirm that port 1433 is being used.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
|||My guess is that there is a firewall between the computers which hasn't got
port 1433 open.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hello,
How to check the port 1433 is open or not?
One server is behind Cisco 1720 router with direct IP address.
One server is behind DSL router, I forward port 21, 80, and 1433 to this
server.
I try to use FTP and Web, and I don't have any problem.
Thanks
"Paul Ibison" wrote:

> My guess is that there is a firewall between the computers which hasn't got
> port 1433 open.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
>
|||It seems you have some sort of network problem rather than a replication
issue, as you can ping the server, but using the same IP address and port
1433 fails at the registration level, even before replication is set up.
Sorry - I doubt I can help you directly much more with this. In my case I
have a network guy that checks the firewall logs to ensure that port 1433
traffic passes from one server to the other through the firewall - maybe you
can have the same done.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Which group should I post to ask the question?
Thanks a lot!!!
"Paul Ibison" wrote:

> It seems you have some sort of network problem rather than a replication
> issue, as you can ping the server, but using the same IP address and port
> 1433 fails at the registration level, even before replication is set up.
> Sorry - I doubt I can help you directly much more with this. In my case I
> have a network guy that checks the firewall logs to ensure that port 1433
> traffic passes from one server to the other through the firewall - maybe you
> can have the same done.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
>
>