Re: Publish SQL 2000 to Inet

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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: Login failed for user (null).
    ... authenticated connection with SQL server. ... Whether or not the remote service accepts the authentication from client ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: server authentication & ASP authentication
    ... on to the client workstation with an authorized Windows account. ... SQL Server with Windows authentication. ...
    (microsoft.public.sqlserver.security)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • 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)