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()).]SQ
L 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.SiteConfigReadOnlyFreeThreade
d.SQLGetConnection() +168

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

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

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

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

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.InitializeApplica
tion() +195

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(HttpApplicat
ion 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

[ Post a follow-up to this message ]

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 authen
ticate?
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

[ Post a follow-up to this message ]