caan not register server 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("
I tried SQL#1 connects SQL#2 and SQL#2 connects SQL#1, I get the same error
message.
Both server can ping each other.
SQL#1 is behind Cisco router 1720 with direct ip address.
SQL#2 is behind DSL router, but ports 21, 80 and 1433 forward to SQL#2.
I can use FTP and WEB on SQL#2.
ThanksDid you make a port scan to indicate wheter the SQL Server is listening on
one
of the adresses ß
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
news:0616C1CD-E6E0-4988-A7B5-017B75F89128@.microsoft.com...
> 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("
> I tried SQL#1 connects SQL#2 and SQL#2 connects SQL#1, I get the same
> error
> message.
> Both server can ping each other.
> SQL#1 is behind Cisco router 1720 with direct ip address.
> SQL#2 is behind DSL router, but ports 21, 80 and 1433 forward to SQL#2.
> I can use FTP and WEB on SQL#2.
>
> Thanks
>|||Hello,
How to use port scan?
Thanks
"Jens Sü�meyer" wrote:
> Did you make a port scan to indicate wheter the SQL Server is listening on
> one
> of the adresses Ã?
> HTH, Jens Sü�meyer.
> --
> http://www.sqlserver2005.de
> --
> "Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:0616C1CD-E6E0-4988-A7B5-017B75F89128@.microsoft.com...
> > 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("
> >
> > I tried SQL#1 connects SQL#2 and SQL#2 connects SQL#1, I get the same
> > error
> > message.
> >
> > Both server can ping each other.
> > SQL#1 is behind Cisco router 1720 with direct ip address.
> > SQL#2 is behind DSL router, but ports 21, 80 and 1433 forward to SQL#2.
> > I can use FTP and WEB on SQL#2.
> >
> >
> > Thanks
> >
> >
>
>|||YOu need to habe some porscanning program like Superscan, there you can
evaluate wehter the port is open and SQL Server is listening.
HTH, Jens Suessmeyer.
"Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
news:EFD93E9B-67CF-467A-B0FB-943BEBC0B11A@.microsoft.com...
> Hello,
> How to use port scan?
> Thanks
> "Jens Süßmeyer" wrote:
>> Did you make a port scan to indicate wheter the SQL Server is listening
>> on
>> one
>> of the adresses ß
>> HTH, Jens Süßmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>> "Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
>> news:0616C1CD-E6E0-4988-A7B5-017B75F89128@.microsoft.com...
>> > 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("
>> >
>> > I tried SQL#1 connects SQL#2 and SQL#2 connects SQL#1, I get the same
>> > error
>> > message.
>> >
>> > Both server can ping each other.
>> > SQL#1 is behind Cisco router 1720 with direct ip address.
>> > SQL#2 is behind DSL router, but ports 21, 80 and 1433 forward to SQL#2.
>> > I can use FTP and WEB on SQL#2.
>> >
>> >
>> > Thanks
>> >
>> >
>>|||You don't need a Port Scan to determine if the SQL server is listening on
the port. A simple Telnet command on port 1433 will tell you if the SQL
server can be reached on port 1433.
Regards
Steen
Jens Süßmeyer wrote:
> YOu need to habe some porscanning program like Superscan, there you
> can evaluate wehter the port is open and SQL Server is listening.
> HTH, Jens Suessmeyer.
> "Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:EFD93E9B-67CF-467A-B0FB-943BEBC0B11A@.microsoft.com...
>> Hello,
>> How to use port scan?
>> Thanks
>> "Jens Süßmeyer" wrote:
>> Did you make a port scan to indicate wheter the SQL Server is
>> listening on
>> one
>> of the adresses ß
>> HTH, Jens Süßmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>> "Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
>> news:0616C1CD-E6E0-4988-A7B5-017B75F89128@.microsoft.com...
>> 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("
>> I tried SQL#1 connects SQL#2 and SQL#2 connects SQL#1, I get the
>> same error
>> message.
>> Both server can ping each other.
>> SQL#1 is behind Cisco router 1720 with direct ip address.
>> SQL#2 is behind DSL router, but ports 21, 80 and 1433 forward to
>> SQL#2. I can use FTP and WEB on SQL#2.
>>
>> Thanks