Windows Server

Jay Warling · Guest

I have a solution that was developed using a domain. I am attempting to
execute the application disconnected from the domain, to troubleshoot a
potential proxy issue with a cXML integration. all code, Commerce Server 2002
SP3, and SQL Server 2000 are local.

I modified all connection strings in the resources to use SQL authentication
and (local) as the data source. Verified this works when authenticated with
the domain. But when I attempt to browse to the site when disconnected from
the domain, I get an error that it can not connect to the Profile service.
Any ideas of what to look at to get this working?

The exception and trace stack appear below.

Thanks,
Jay

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.

Source Error:

An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.

Stack Trace:

[COMException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does not exist or access denied.]

Microsoft.CommerceServer.Interop.Profiles.ProfileServiceClass.Initialize(String sConfigStore, String sCatalog) +0
Microsoft.CommerceServer.Runtime.Profiles.ProfileContext..ctor(String
profilesvcConnstr, String providerConnstr, String bdaoConnstr, DebugContext
dbgContext) +833

[CommerceProfileSystemException: Failed to initialize profile service handle.]
Microsoft.CommerceServer.Runtime.Profiles.ProfileContext..ctor(String
profilesvcConnstr, String providerConnstr, String bdaoConnstr, DebugContext
dbgContext) +950

Microsoft.CommerceServer.Runtime.Profiles.CommerceProfileModule.CreateProfileContext() +515

Microsoft.CommerceServer.Runtime.Profiles.CommerceProfileModule.get_ProfileContext() +80

Microsoft.CommerceServer.Runtime.Profiles.CommerceProfileModule.Init(HttpApplication appInstance) +116
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

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032

Wyatt Preul · Guest

You might want to check that you do not have a personal firewall or anything
turned on.

"Jay Warling" wrote:

Colin Bowern · Guest

Jay,

Did you get the connection string in the Partitions tab of your Profile Data
Source properties in Commerce Server Manager?

I've missed that one from time to time and it always throws me off until
I remember that it needs to be updated as well. :)

Cheers,
Colin

Jay Warling · Guest

Colin,

Thanks, that was it. Completely forgot about that setting. Interstingly I
didn't see it in the ResourceProps table of the CS Admin DB either. It must
be stored somewhere else.

Thanks,
Jay
"Colin Bowern" wrote:

	Windows Server Forum Index -> Commerce Server	All times are GMT
Page 1 of 1