'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOpen E
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOpen E

 
Post new topic   Reply to topic    Windows Server Forum Index -> Commerce Server
Author Message
Joy
Guest
Posted: Wed Sep 21, 2005 8:51 am    Post subject: 'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOpen E Reply with quote
Our site works fine in our DEV environment where the web server and the
database server is on the same server, but when I unpup it to my Test
environment where I've CS2002 on a Win2003 svr and the database on a
different win2003 svr....I get the error below.

So to test I unpuped the csharp solution site and when I access the login
page I get the same error below.

Error in Commerce Administration Object : Description -
'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does not exist or access denied.'


And this is the output when I access the Login.aspx page....


COMException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server
does not exist or access denied.]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String
Password, Int32 Options) +0
SharedFns.ReadSQLDbLocale(String& strAdminConn) +98
SharedFns.SQLGetConnStr() +339

Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeThreaded.SQLGetConnection() +168

Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeThreaded.Initialize(String bstrSiteName) +291

[CommerceException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does
not exist or access denied.]
SharedFns.ThrowCommerceException(String message, Exception inner) +55

Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeThreaded.Initialize(String bstrSiteName) +4234

Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceCollection..ctor(String siteName) +216

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.InitializeApplication() +195

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(HttpApplication appInstance) +76
System.Web.HttpApplication.InitModules() +100
System.Web.HttpApplication.InitInternal(HttpContext context,
HttpApplicationState state, MethodInfo[] handlers) +1330

System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext
context) +392
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
context) +256
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +414
Back to top
Joy
Guest
Posted: Wed Sep 21, 2005 4:51 pm    Post subject: Re: 'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOp Reply with quote
One more thing..the BizDesk work fine without any problems...

- Joy

"Joy" wrote:

Quote:
Colin,
Thnx for the quick reply..

Yes!...I tried using the profiler. Unfortunately I don't see any connection
attempts in the trace when I try to access the site. It is as if there is no
connecction attempt from the CS web server. I've double-checked all the
connection strings and the SQL server names. One thing I've noticed is that
the CS server used named pipes while connecting to the SQL server. Is that an
issue...

Thanks and hope you can help me..

- Joy
"Colin Bowern" wrote:

Hi Joy,

It sounds like a potential authentication issue between the sites. Have
you used SQL Server Profiler to see what account may be attempting to authenticate?
Are your connect strings all correct including the one in the profiles data
source?

Thanks,
Colin

Our site works fine in our DEV environment where the web server and
the database server is on the same server, but when I unpup it to my
Test environment where I've CS2002 on a Win2003 svr and the database
on a different win2003 svr....I get the error below.

So to test I unpuped the csharp solution site and when I access the
login page I get the same error below.

Error in Commerce Administration Object : Description -
'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied.'

And this is the output when I access the Login.aspx page....

COMException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server
does not exist or access denied.]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
String
Password, Int32 Options) +0
SharedFns.ReadSQLDbLocale(String& strAdminConn) +98
SharedFns.SQLGetConnStr() +339
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeT
hreaded.SQLGetConnection() +168

Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeT
hreaded.Initialize(String bstrSiteName) +291

[CommerceException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server
does
not exist or access denied.]
SharedFns.ThrowCommerceException(String message, Exception inner)
+55
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeT
hreaded.Initialize(String bstrSiteName) +4234

Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceCollect
ion..ctor(String siteName) +216

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.InitializeA
pplication() +195

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(HttpAp
plication appInstance) +76
System.Web.HttpApplication.InitModules() +100
System.Web.HttpApplication.InitInternal(HttpContext context,
HttpApplicationState state, MethodInfo[] handlers) +1330
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpCon
text
context) +392

System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
context) +256
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
+414


Back to top
Colin Bowern
Guest
Posted: Wed Sep 21, 2005 4:51 pm    Post subject: Re: 'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOp Reply with quote
Hi Joy,

It sounds like a potential authentication issue between the sites. Have
you used SQL Server Profiler to see what account may be attempting to authenticate?
Are your connect strings all correct including the one in the profiles data
source?

Thanks,
Colin

Quote:
Our site works fine in our DEV environment where the web server and
the database server is on the same server, but when I unpup it to my
Test environment where I've CS2002 on a Win2003 svr and the database
on a different win2003 svr....I get the error below.

So to test I unpuped the csharp solution site and when I access the
login page I get the same error below.

Error in Commerce Administration Object : Description -
'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied.'

And this is the output when I access the Login.aspx page....

COMException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server
does not exist or access denied.]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
String
Password, Int32 Options) +0
SharedFns.ReadSQLDbLocale(String& strAdminConn) +98
SharedFns.SQLGetConnStr() +339
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeT
hreaded.SQLGetConnection() +168

Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeT
hreaded.Initialize(String bstrSiteName) +291

[CommerceException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server
does
not exist or access denied.]
SharedFns.ThrowCommerceException(String message, Exception inner)
+55
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeT
hreaded.Initialize(String bstrSiteName) +4234

Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceCollect
ion..ctor(String siteName) +216

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.InitializeA
pplication() +195

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(HttpAp
plication appInstance) +76
System.Web.HttpApplication.InitModules() +100
System.Web.HttpApplication.InitInternal(HttpContext context,
HttpApplicationState state, MethodInfo[] handlers) +1330
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpCon
text
context) +392

System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
context) +256
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
+41
Back to top
Joy
Guest
Posted: Wed Sep 21, 2005 4:51 pm    Post subject: Re: 'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOp Reply with quote
Colin,
Thnx for the quick reply..

Yes!...I tried using the profiler. Unfortunately I don't see any connection
attempts in the trace when I try to access the site. It is as if there is no
connecction attempt from the CS web server. I've double-checked all the
connection strings and the SQL server names. One thing I've noticed is that
the CS server used named pipes while connecting to the SQL server. Is that an
issue...

Thanks and hope you can help me..

- Joy
"Colin Bowern" wrote:

Quote:
Hi Joy,

It sounds like a potential authentication issue between the sites. Have
you used SQL Server Profiler to see what account may be attempting to authenticate?
Are your connect strings all correct including the one in the profiles data
source?

Thanks,
Colin

Our site works fine in our DEV environment where the web server and
the database server is on the same server, but when I unpup it to my
Test environment where I've CS2002 on a Win2003 svr and the database
on a different win2003 svr....I get the error below.

So to test I unpuped the csharp solution site and when I access the
login page I get the same error below.

Error in Commerce Administration Object : Description -
'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied.'

And this is the output when I access the Login.aspx page....

COMException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server
does not exist or access denied.]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
String
Password, Int32 Options) +0
SharedFns.ReadSQLDbLocale(String& strAdminConn) +98
SharedFns.SQLGetConnStr() +339
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeT
hreaded.SQLGetConnection() +168

Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeT
hreaded.Initialize(String bstrSiteName) +291

[CommerceException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server
does
not exist or access denied.]
SharedFns.ThrowCommerceException(String message, Exception inner)
+55
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeT
hreaded.Initialize(String bstrSiteName) +4234

Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceCollect
ion..ctor(String siteName) +216

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.InitializeA
pplication() +195

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(HttpAp
plication appInstance) +76
System.Web.HttpApplication.InitModules() +100
System.Web.HttpApplication.InitInternal(HttpContext context,
HttpApplicationState state, MethodInfo[] handlers) +1330
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpCon
text
context) +392

System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
context) +256
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
+414


Back to top
Vinayak Tadas[MSFT]
Guest
Posted: Thu Sep 22, 2005 8:51 am    Post subject: Re: 'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOp Reply with quote
See this article on deploying a Commerce server site

http://blogs.msdn.com/vinayakt/archive/2005/09/22/472641.aspx
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][ConnectionOpen Err
thread-index: AcW+yW9abaezdDzwSKeGFwPPb2AGRw==
X-WBNR-Posting-Host: 67.96.13.31
From: =?Utf-8?B?Sm95?= <Joy@discussions.microsoft.com>
References: <F4967481-2D16-4FF6-A33A-470A92EC993C@microsoft.com>
<86cd1bdd16fc8c78cac17590e8c@msnews.microsoft.com>
<90B9AFA1-BD6A-4E7F-BF04-5CF7C206DDAD@microsoft.com>
Subject: Re: 'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOpen Err
Date: Wed, 21 Sep 2005 09:28:01 -0700
Lines: 89
Message-ID: <32DDDA11-A89C-40FF-A682-1AEBFE85B865@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:3517
X-Tomcat-NG: microsoft.public.commerceserver.general

One more thing..the BizDesk work fine without any problems...

- Joy

"Joy" wrote:

Quote:
Colin,
Thnx for the quick reply..

Yes!...I tried using the profiler. Unfortunately I don't see any
connection
attempts in the trace when I try to access the site. It is as if there is
no
connecction attempt from the CS web server. I've double-checked all the
connection strings and the SQL server names. One thing I've noticed is
that
the CS server used named pipes while connecting to the SQL server. Is
that an
issue...

Thanks and hope you can help me..

- Joy
"Colin Bowern" wrote:

Hi Joy,

It sounds like a potential authentication issue between the sites.
Have
you used SQL Server Profiler to see what account may be attempting to
authenticate?
Are your connect strings all correct including the one in the profiles
data
source?

Thanks,
Colin

Our site works fine in our DEV environment where the web server and
the database server is on the same server, but when I unpup it to my
Test environment where I've CS2002 on a Win2003 svr and the database
on a different win2003 svr....I get the error below.

So to test I unpuped the csharp solution site and when I access the
login page I get the same error below.

Error in Commerce Administration Object : Description -
'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied.'

And this is the output when I access the Login.aspx page....

COMException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server
does not exist or access denied.]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
String
Password, Int32 Options) +0
SharedFns.ReadSQLDbLocale(String& strAdminConn) +98
SharedFns.SQLGetConnStr() +339
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeT
hreaded.SQLGetConnection() +168

Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeT
hreaded.Initialize(String bstrSiteName) +291

[CommerceException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server
does
not exist or access denied.]
SharedFns.ThrowCommerceException(String message, Exception inner)
+55
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeT
hreaded.Initialize(String bstrSiteName) +4234

Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceCollect
ion..ctor(String siteName) +216

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.InitializeA
pplication() +195

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(HttpAp
plication appInstance) +76
System.Web.HttpApplication.InitModules() +100
System.Web.HttpApplication.InitInternal(HttpContext context,
HttpApplicationState state, MethodInfo[] handlers) +1330
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpCon
text
context) +392

System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
context) +256
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
+414


Back to top
Colin Bowern
Guest
Posted: Thu Sep 22, 2005 4:51 pm    Post subject: Re: 'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOp Reply with quote
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

Quote:
Colin,
Thnx for the quick reply..
Yes!...I tried using the profiler. Unfortunately I don't see any
connection attempts in the trace when I try to access the site. It is
as if there is no connecction attempt from the CS web server. I've
double-checked all the connection strings and the SQL server names.
One thing I've noticed is that the CS server used named pipes while
connecting to the SQL server. Is that an issue...

Thanks and hope you can help me..

- Joy
"Colin Bowern" wrote:
Hi Joy,

It sounds like a potential authentication issue between the sites.
Have you used SQL Server Profiler to see what account may be
attempting to authenticate? Are your connect strings all correct
including the one in the profiles data source?

Thanks,
Colin
Our site works fine in our DEV environment where the web server and
the database server is on the same server, but when I unpup it to my
Test environment where I've CS2002 on a Win2003 svr and the
database on a different win2003 svr....I get the error below.

So to test I unpuped the csharp solution site and when I access the
login page I get the same error below.

Error in Commerce Administration Object : Description -
'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied.'

And this is the output when I access the Login.aspx page....

COMException (0x80004005): [DBNETLIB][ConnectionOpen
(Connect()).]SQL
Server
does not exist or access denied.]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
String
Password, Int32 Options) +0
SharedFns.ReadSQLDbLocale(String& strAdminConn) +98
SharedFns.SQLGetConnStr() +339
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFre
eT
hreaded.SQLGetConnection() +168
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFre
eT hreaded.Initialize(String bstrSiteName) +291

[CommerceException: [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server
does
not exist or access denied.]
SharedFns.ThrowCommerceException(String message, Exception inner)
+55
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFre
eT
hreaded.Initialize(String bstrSiteName) +4234
Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceColle
ct ion..ctor(String siteName) +216

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Initializ
eA pplication() +195

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(Http
Ap
plication appInstance) +76
System.Web.HttpApplication.InitModules() +100
System.Web.HttpApplication.InitInternal(HttpContext context,
HttpApplicationState state, MethodInfo[] handlers) +1330
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpC
on
text
context) +392
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
context) +256
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
+414
Back to top
Joy
Guest
Posted: Tue Sep 27, 2005 8:51 am    Post subject: Re: 'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOp Reply with quote
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:

Quote:
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

Colin,
Thnx for the quick reply..
Yes!...I tried using the profiler. Unfortunately I don't see any
connection attempts in the trace when I try to access the site. It is
as if there is no connecction attempt from the CS web server. I've
double-checked all the connection strings and the SQL server names.
One thing I've noticed is that the CS server used named pipes while
connecting to the SQL server. Is that an issue...

Thanks and hope you can help me..

- Joy
"Colin Bowern" wrote:
Hi Joy,

It sounds like a potential authentication issue between the sites.
Have you used SQL Server Profiler to see what account may be
attempting to authenticate? Are your connect strings all correct
including the one in the profiles data source?

Thanks,
Colin
Our site works fine in our DEV environment where the web server and
the database server is on the same server, but when I unpup it to my
Test environment where I've CS2002 on a Win2003 svr and the
database on a different win2003 svr....I get the error below.

So to test I unpuped the csharp solution site and when I access the
login page I get the same error below.

Error in Commerce Administration Object : Description -
'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied.'

And this is the output when I access the Login.aspx page....

COMException (0x80004005): [DBNETLIB][ConnectionOpen
(Connect()).]SQL
Server
does not exist or access denied.]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
String
Password, Int32 Options) +0
SharedFns.ReadSQLDbLocale(String& strAdminConn) +98
SharedFns.SQLGetConnStr() +339
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFre
eT
hreaded.SQLGetConnection() +168
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFre
eT hreaded.Initialize(String bstrSiteName) +291

[CommerceException: [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server
does
not exist or access denied.]
SharedFns.ThrowCommerceException(String message, Exception inner)
+55
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFre
eT
hreaded.Initialize(String bstrSiteName) +4234
Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceColle
ct ion..ctor(String siteName) +216

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Initializ
eA pplication() +195

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(Http
Ap
plication appInstance) +76
System.Web.HttpApplication.InitModules() +100
System.Web.HttpApplication.InitInternal(HttpContext context,
HttpApplicationState state, MethodInfo[] handlers) +1330
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpC
on
text
context) +392
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
context) +256
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
+414



Back to top
Vinayak Tadas[MSFT]
Guest
Posted: Tue Sep 27, 2005 8:51 am    Post subject: Re: 'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOp Reply with quote
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][ConnectionOpen Err
thread-index: AcXDI2SGoyQ3nzNYRHKWZy5+RlTdsg==
X-WBNR-Posting-Host: 64.132.72.135
From: =?Utf-8?B?Sm95?= <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][ConnectionOpen 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:

Quote:
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

Colin,
Thnx for the quick reply..
Yes!...I tried using the profiler. Unfortunately I don't see any
connection attempts in the trace when I try to access the site. It is
as if there is no connecction attempt from the CS web server. I've
double-checked all the connection strings and the SQL server names.
One thing I've noticed is that the CS server used named pipes while
connecting to the SQL server. Is that an issue...

Thanks and hope you can help me..

- Joy
"Colin Bowern" wrote:
Hi Joy,

It sounds like a potential authentication issue between the sites.
Have you used SQL Server Profiler to see what account may be
attempting to authenticate? Are your connect strings all correct
including the one in the profiles data source?

Thanks,
Colin
Our site works fine in our DEV environment where the web server and
the database server is on the same server, but when I unpup it to my
Test environment where I've CS2002 on a Win2003 svr and the
database on a different win2003 svr....I get the error below.

So to test I unpuped the csharp solution site and when I access the
login page I get the same error below.

Error in Commerce Administration Object : Description -
'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied.'

And this is the output when I access the Login.aspx page....

COMException (0x80004005): [DBNETLIB][ConnectionOpen
(Connect()).]SQL
Server
does not exist or access denied.]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
String
Password, Int32 Options) +0
SharedFns.ReadSQLDbLocale(String& strAdminConn) +98
SharedFns.SQLGetConnStr() +339
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFre
eT
hreaded.SQLGetConnection() +168
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFre
eT hreaded.Initialize(String bstrSiteName) +291

[CommerceException: [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server
does
not exist or access denied.]
SharedFns.ThrowCommerceException(String message, Exception inner)
+55
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFre
eT
hreaded.Initialize(String bstrSiteName) +4234
Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceColle
ct ion..ctor(String siteName) +216

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Initializ
eA pplication() +195

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(Http
Ap
plication appInstance) +76
System.Web.HttpApplication.InitModules() +100
System.Web.HttpApplication.InitInternal(HttpContext context,
HttpApplicationState state, MethodInfo[] handlers) +1330
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpC
on
text
context) +392
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
context) +256
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
+414



Back to top
Joy
Guest
Posted: Tue Sep 27, 2005 4:51 pm    Post subject: Re: 'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOp Reply with quote
No..they don't share the AD domain. The webservers are in a separate vlan in
the dmz. Can't we just configure this to use a SQL login.

This site is an asp site ..so no web.config.


- Joy

"Colin Bowern" wrote:

Quote:
Hi Joy,

Do the servers in the DMZ share an Active Directory domain or forest with
the SQL Server in the internal network? In your web.config do you have impersonation
set, and if so, what is it set to?

Cheers,
Colin

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
Colin,
Thnx for the quick reply..
Yes!...I tried using the profiler. Unfortunately I don't see any
connection attempts in the trace when I try to access the site. It
is
as if there is no connecction attempt from the CS web server. I've
double-checked all the connection strings and the SQL server names.
One thing I've noticed is that the CS server used named pipes while
connecting to the SQL server. Is that an issue...
Thanks and hope you can help me..

- Joy
"Colin Bowern" wrote:
Hi Joy,

It sounds like a potential authentication issue between the sites.
Have you used SQL Server Profiler to see what account may be
attempting to authenticate? Are your connect strings all correct
including the one in the profiles data source?

Thanks,
Colin
Our site works fine in our DEV environment where the web server
and the database server is on the same server, but when I unpup it
to my Test environment where I've CS2002 on a Win2003 svr and the
database on a different win2003 svr....I get the error below.

So to test I unpuped the csharp solution site and when I access
the login page I get the same error below.

Error in Commerce Administration Object : Description -
'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied.'

And this is the output when I access the Login.aspx page....

COMException (0x80004005): [DBNETLIB][ConnectionOpen
(Connect()).]SQL
Server
does not exist or access denied.]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
String
Password, Int32 Options) +0
SharedFns.ReadSQLDbLocale(String& strAdminConn) +98
SharedFns.SQLGetConnStr() +339
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyF
re
eT
hreaded.SQLGetConnection() +168
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyF
re
eT hreaded.Initialize(String bstrSiteName) +291
[CommerceException: [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server
does
not exist or access denied.]
SharedFns.ThrowCommerceException(String message, Exception inner)
+55
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyF
re
eT
hreaded.Initialize(String bstrSiteName) +4234
Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceCol
le
ct ion..ctor(String siteName) +216
Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Initial
iz eA pplication() +195

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(Ht
tp
Ap
plication appInstance) +76
System.Web.HttpApplication.InitModules() +100
System.Web.HttpApplication.InitInternal(HttpContext context,
HttpApplicationState state, MethodInfo[] handlers) +1330
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(Htt
pC
on
text
context) +392
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpConte
xt
context) +256
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest
wr)
+414


Back to top
Colin Bowern
Guest
Posted: Tue Sep 27, 2005 4:51 pm    Post subject: Re: 'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOp Reply with quote
Hi Joy,

Do the servers in the DMZ share an Active Directory domain or forest with
the SQL Server in the internal network? In your web.config do you have impersonation
set, and if so, what is it set to?

Cheers,
Colin

Quote:
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
Colin,
Thnx for the quick reply..
Yes!...I tried using the profiler. Unfortunately I don't see any
connection attempts in the trace when I try to access the site. It
is
as if there is no connecction attempt from the CS web server. I've
double-checked all the connection strings and the SQL server names.
One thing I've noticed is that the CS server used named pipes while
connecting to the SQL server. Is that an issue...
Thanks and hope you can help me..

- Joy
"Colin Bowern" wrote:
Hi Joy,

It sounds like a potential authentication issue between the sites.
Have you used SQL Server Profiler to see what account may be
attempting to authenticate? Are your connect strings all correct
including the one in the profiles data source?

Thanks,
Colin
Our site works fine in our DEV environment where the web server
and the database server is on the same server, but when I unpup it
to my Test environment where I've CS2002 on a Win2003 svr and the
database on a different win2003 svr....I get the error below.

So to test I unpuped the csharp solution site and when I access
the login page I get the same error below.

Error in Commerce Administration Object : Description -
'SiteConfigReadOnly:Initialize : [DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied.'

And this is the output when I access the Login.aspx page....

COMException (0x80004005): [DBNETLIB][ConnectionOpen
(Connect()).]SQL
Server
does not exist or access denied.]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
String
Password, Int32 Options) +0
SharedFns.ReadSQLDbLocale(String& strAdminConn) +98
SharedFns.SQLGetConnStr() +339
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyF
re
eT
hreaded.SQLGetConnection() +168
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyF
re
eT hreaded.Initialize(String bstrSiteName) +291
[CommerceException: [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server
does
not exist or access denied.]
SharedFns.ThrowCommerceException(String message, Exception inner)
+55
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyF
re
eT
hreaded.Initialize(String bstrSiteName) +4234
Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceCol
le
ct ion..ctor(String siteName) +216
Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Initial
iz eA pplication() +195

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(Ht
tp
Ap
plication appInstance) +76
System.Web.HttpApplication.InitModules() +100
System.Web.HttpApplication.InitInternal(HttpContext context,
HttpApplicationState state, MethodInfo[] handlers) +1330
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(Htt
pC
on
text
context) +392
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpConte
xt
context) +256
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest
wr)
+414
Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Commerce Server All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB