Re: Cannot connect to SQL Server 2000 from II6

From: Kristofer Gafvert (kgafvert_at_NEWSilopia.com)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 17:36:08 +0200

Hello,

You need SP3 or above for SQL Server. If i remember correctly, SQL Server
will not accept any connections unless SP3 is installed, and your error
description fits into this (works locally, but not remotly).

Also see:

"PRB: Windows Server 2003 Support for SQL Server 2000"
http://support.microsoft.com/default.aspx?kbid=329329 

-- 
Regards,
Kristofer Gafvert
http://www.ilopia.com
"Rajeev Ramanujan" <rajeevramanujan@hotmail.com> wrote in message
news:%23AhpYyioEHA.2900@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I'm using ISAPI dll which runs on IIS6 web server(OS: Windows 2003) and
> tries to connect to SQL Server 2000 installed in Windows 2003 Server. I
> have installed Service Pack 2 for SQL Server in the Windows 2003 server.
>
> The web server and database server are on different PC'. But when I
> tries to connect to the SQL Server through the ISAPI web site I get the
> following error in the browser:
>
> "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied."
>
> Everything works fine if the OS is Windows 2000 Server, SQL Server 200
> and IIS 5.
>
> If the ISAPI Web site (IIS 6) and the SQL Server 2000 are on the same
> Windows 2003 Server, then also everything is fine, the error is raised
> only when the Web Server (IIS 6) and the database server are on
> different PC'.
>
>          Does anyone has any soltions for this? How do i solve this? Do
> I need to make/change any settings in SQL Server 2000/Windows 2003
> Server or IIS6 to make it work with?
>
> Thanks
> Rajeev Ramanujan
>

Relevant Pages

  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... 2- Mixed Authentication (through SQL Server logins and Windows accounts) ...
    (microsoft.public.sqlserver.clients)
  • RE: My Documents Redirection error
    ... We can upgrade the instance SharePoint ... >> is no need to manually migrate data from MSDE to SQL server and all dada ... >> How to back up and restore http://companyweb data in Windows Small ...
    (microsoft.public.windows.server.sbs)
  • 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: server authentication & ASP authentication
    ... The SQL Server and web server are on the same machine (Windows 2000). ... Use windows instead of standard authentication on SQL Server. ...
    (microsoft.public.sqlserver.security)
  • RE: My Documents Redirection error
    ... > is no need to manually migrate data from MSDE to SQL server and all dada is ... > How to back up and restore http://companyweb data in Windows Small Business ... Insert the Microsoft Windows Small Business Server 2003 Premium ...
    (microsoft.public.windows.server.sbs)