Re: Cannot connect to SQL Server 2000 from II6

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

From: Tom Kaminski [MVP] ((A_at_T))
Date: 09/24/04 

Date: Fri, 24 Sep 2004 08:11:21 -0400

"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?

http://support.microsoft.com/?kbid=328306 

-- 
Tom Kaminski IIS MVP
http://www.microsoft.com/windowsserver2003/community/centers/iis/
http://mvp.support.microsoft.com/
http://www.iisfaq.com/
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://www.tryiis.com

Relevant Pages

  • RE: IIS6 on W2k3 DCs
    ... In the case of a web server, ... >Organizations who want fault tolerance put resources on ... >But Small Business Server 2003 runs with IIS on our domain controller. ...
    (Focus-Microsoft)
  • Re: middle tier recommendations
    ... I forgot to mention I do have a standby database server for failover. ... >> That depends on the amount of use that interface will get. ... >> is scalable, you can put your app, with DLLs, on any web server without ... >>> inherent performance issues with IIS ...
    (microsoft.public.dotnet.framework)
  • Re: IIS6 on W2k3 DCs
    ... Didn't an IIS server survive OpenHackIV with IIS, ... In the case of a web server, ... >>Your box is your domain controller, and its your exchange server, so it ...
    (Focus-Microsoft)
  • Re: Possible To Create Web Application On Other Than Local Server
    ... "Scott" wrote in message news:677k90t3kfd3etmpbpkrhca34lea7e8kaa@4ax.com... ... :>: web server that will be hosting. ... This means you do not have to have IIS running local. ... IE and call for the virtual path on the web server so I can test the page. ...
    (microsoft.public.inetserver.asp.general)
  • IIS is going crazy
    ... I tried reinstalling the IIS on XP but I still get the same errors. ... Computer: KENNY-XP ... The server failed to load application '/LM/W3SVC'. ... When I try to create a NEW WEB in frontpage I get: THe Web server at http://kenny-xp does not appear to have the windows sharepoint services installed ...
    (microsoft.public.windowsxp.help_and_support)