Publish SQL 2000 to Inet
- From: "beto @ southworks" <beto@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 4 Oct 2005 14:02:49 -0300
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.
.
- Prev by Date: RE: Access Dennied trying to use OWA
- Next by Date: Re: How to redirect ports on the SAME interface?
- Previous by thread: RE: Access Dennied trying to use OWA
- Next by thread: Re: How to redirect ports on the SAME interface?
- Index(es):
Relevant Pages
|
Loading