Publish SQL 2000 to Inet



Hi! I need to publish a SQL2000 server to Inet through an ISA Server 2004.
Have tried everything I've found and I cannot get it working. This is my
configuration.

* My SQL Server Machine is a SecureNAT client.
* I've run the server publishing wizard on the ISA Server machine and
published the SQL Server on it's default port (1433).
* SQL Server instance name IS NOT the Default instance name (does it
matters?)
* On the client machine (inet) I create an Alias using the ISA Server Public
IP Address as Server Name, so the client does not have to resolve the
connection port.

When I try to register the SQL instance on the client machine I get:
"SQL Server registration failed because of the connection failure displayed
below. Do you wish to Register anyway?
SQL Server does not exist or access denied.
ConnectionOpen (Connect())"

If I run a trace on the ISA Server to watch incoming connections I can see
that the incoming from the external IP address connection is not being
denied, but nothing happens.
I get the same if I try to Register the SQL Instance from a host in the LAN
looping through the ISA Server for testing purposes.


Is there a way to troubleshoot this Registration process? I can´t see where
it's being stopped or what is missing.
Thanks a Lot!

Beto.


.



Relevant Pages

  • Re: How to allow POP3 SSL connections w ISA 2004
    ... I am at SP3 for ISA Server 2004. ... Yes, you are correct, this is mostly an Outlook settings issue, you can try ... Please also help to gather the ISA logs: ...
    (microsoft.public.windows.server.sbs)
  • Re: How to allow POP3 SSL connections w ISA 2004
    ... the Outlook group as well. ... Firewall Client configuration for ISA Server 2004. ...
    (microsoft.public.windows.server.sbs)
  • RE: Simple ISA 2004 questions
    ... You'd better create a new GPO for IE proxy, ... Run "gpmc.msc" in SBS server, ... ISA Server 2004 Query can give you some help. ... In the Microsoft Internet Security and Acceleration Server 2004 console, ...
    (microsoft.public.windows.server.sbs)
  • Re: ISA 2006 Basic Configuration
    ... Does the AD/DNS Server have the ISP's DNS properly configured as a Forwarder? ... Microsoft Internet Security & Acceleration Server: ... Microsoft ISA Server Partners: Partner Hardware Solutions ... The routing table for the network adapter Internal includes IP address ranges that are not defined in the array-level network Internal, ...
    (microsoft.public.isa.configuration)
  • Re: Clickonce and license question question
    ... updates the SQL server at our ISP that the license key is now in use. ... They are unable to register the application and they get an SQL error. ...
    (microsoft.public.dotnet.framework.windowsforms)

Loading