I think you are running into the "double hop" issue when the web service
and the sql server are on different machibnes

There is a question in this edition of MSDN magazine
http://msdn.microsoft.com/msdnmag/issues/05/05/WebQA/
Search for "double-hop" in the above article. This also points to a web
cast which you may find useful


Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure!  For more info visit http://www.microsoft.com/security.  Please
reply to the newsgroups only


--------------------
Thread-Topic: 'SiteConfigReadOnly:Initialize : [DBNETLIB][Connection
Open Err
thread-index: AcXDI2SGoyQ3nzNYRHKWZy5+RlTdsg==
X-WBNR-Posting-Host: 64.132.72.135
From: examnotes <Joy@discussions.microsoft.com>
References:  <F4967481-2D16-4FF6-A33A-470A92EC993C@microsoft.com>
<86cd1bdd16fc8c78cac17590e8c@msnews.microsoft.com>
<90B9AFA1-BD6A-4E7F-BF04-5CF7C206DDAD@microsoft.com>
<86cd1bdd188d8c78d6bb57fe325@msnews.microsoft.com>
Subject: Re: 'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionO
pen Err
Date: Mon, 26 Sep 2005 22:22:02 -0700
Lines: 105
Message-ID: <26DF8C4C-FB0F-4E36-83CE-010FEDAF6655@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3560
X-Tomcat-NG: microsoft.public.commerceserver.general

Colin,
The environment works when the App pool identity and the IIS anonymous
user runs under a domain account which has access to the SQL server.
Unfortunately In our production environment the CS and the web server will
be
in the DMZ and the SQL server will be inside the network. So the windows
auth
will not work in this case. The app pool and the anon user need to work
under
the IWAM or IUSR.. acct...but CS2002 seem to break in this situation.

- Joy

"Colin Bowern" wrote:

> Hi Joy,
>
> Does your application pool identity have access to the SQL Server?  Can
you
> run Query Analyzer from the web server under that identity and try and
connect
> to the SQL box?
>
> Cheers,
> Colin
> 
>
>
>

[ Post a follow-up to this message ]