Re: Publish SQL 2000 to Inet

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for your reply Virgil! I'm using SQL Server authentication, for
testing purposes I've registered the SQL Server instance from a workstation
inside the LAN without looping through the ISA Server and I've registered it
succesfully.
So there is no doubt for me that it must be an ISA Server issue.

I'm not sure if it is worth to comment but when I've installed SQL Server
I've configured the TCP/IP Port to 2866. Then I've change it to the default
port value (1433) to make sure that it wasn´t my problem.

Thanks Again Virgil!

"ZVR" <nospamever@xxxxxx> wrote in message
news:O9KdnXjXUaIER9_eRVn-iA@xxxxxxxxxxxxx
> What kind of authentication are you using with your SQL server? Integrated
> authentication or SQL-server authentication. In other words where is your
> SQL login defined - at the SQL Server level or as a Domain/active
> Directory account. If you're trying with Integrated Authentication it will
> probably not work because you don't have access to the domain database
> from the Internet.
>
> Virgil
>
>
>
>
> "beto @ southworks" <beto@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:eEor1VQyFHA.2132@xxxxxxxxxxxxxxxxxxxxxxx
>> 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: Msg 15404: Could not obtain information about user
    ... not register the Service Principal Name (SPN) for the SQL Server service. ... authentication to fall back to NTLM instead of Kerberos. ...
    (microsoft.public.sqlserver.security)
  • Re: Beta of Microsoft Certification Exam 70-442
    ... I have registered for the SQL Server Beta test too. ... To register visit one of our independent testing providers: ... exam will receive a free exam voucher* for any Microsoft Certification ...
    (microsoft.public.cert.mcdba)
  • Re: impersonation
    ... will need to use setSPN.exe and register a new service principal name: ... backend SQL Server to make sure everything is setup correctly, ... >>I would like to use KERBEROS delegation to access an SQL Server database ... >> Both the IIS and the SQL server are part of a domain. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Whats My Password?
    ... Windows Authentication or SQL Server Authentication. ... (Perhaps I have to drive to Microsoft to ... different SQL Server instance name or with the full version of SQL Server, ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Replication Server Reconciler Failed (29045-29006) Help Pleaseeee
    ... Did you register the sscerp20.dll and sscesa20.dll successfully? ... but do you have the default snapshot directory for you ... | I am using SQL CE 2.0 and SQL Server 2000. ... | The DLL SSCERP10.dll must be registered on the IIS server. ...
    (microsoft.public.sqlserver.ce)