Commerce Server General - Newbie question in FP1

Author

Newbie question in FP1

Jeffrey R Dempsey

2005-05-16, 2:52 am

Hello,

I am pretty new to CS and SQL Server, so here goes...

I have performed the installation of CS2002, and FP1, and I have a
permissions problem. Is there a web site I can go to for errors in setting
up CD2002 and FP1?

Here are my stats:
CS2002 Developer Edition
SQL Server 2000 Developer edition
Windows Server 2003

I have set up the permissions per pp23 - 27 of the eBook "Integrating
Inventory Data iwith a Catalog System" from the MS site.

Questions:
What should I put in, on page 27 for "YourSiteName"? I have accepted all of
the defaults on the install.

My SQL Server name is \\dempsey-server\store

Also, when I try the "Adjust Inventory Tool" on p42, I get the following
dialog box:
"SQL Server does not exist or access denied" - Thanks, but that tells me
nothing if I don't know what you're looking for...
and then...
"Unable to get data from database, application cannot continue"
Then the form from p 43 flashes, and then disappears.

Question:
What is this application looking for, and what user name is it using, and
what is it accessing?
Are there any logs for this application?
Is there a better book on doing all of this, like a primer? I need
something like this:
Step 1.
Do this.
If you are successful with step 1, the following appears. If not, find out
why.

I just get the feeling, with my newness to CS2002, and all of the
applications that must be installed, this is a house of cards, and one wrong
placement will cause the whole thing not to work. Yes, I am frustrated.

Also,
When I go to the http://localhost/InventoryData, I get the following:

Server Error in '/InventoryData' Application.
--------------------------------------------------------------------------------

Access is 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.UnauthorizedAccessException: Access is denied.

ASP.NET is not authorized to access the requested resource. Consider
granting access rights to the resource to the ASP.NET request identity.
ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or
Network Service on IIS 6) that is used if the application is not
impersonating. If the application is impersonating via <identity
impersonate="true"/>, the identity will be the anonymous user (typically
IUSR_MACHINENAME) or the authenticated request user.

To grant ASP.NET write access to a file, right-click the file in Explorer,
choose "Properties" and select the Security tab. Click "Add" to add the
appropriate user or group. Highlight the ASP.NET account, and check the
boxes for the desired access.

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:

[UnauthorizedAccessException: Access is denied.]
SharedFns.WriteToEventLog(String& sString, Int16& iLogType, Int32&
iEventID) +34
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeThreaded.Initialize(String
bstrSiteName) +4215
Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceCollection..ctor(String
siteName) +278
Microsoft.CommerceServer.Runtime.CommerceApplicationModule.InitializeApplication()
+194
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

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

Colin Bowern

2005-05-16, 5:50 pm

Hi Jeffrey,

I'm dealing with the same exception error that you are running into with
regards to the event log function. I'm deploying CS2002 Standard SP3/FP1 +
SQL2000 Standard SP4 + WS2003 Standard SP1 to production. The error seems
to be focused on the COM+ identity and permissions. I've got another copy
of it working in a pre-production test environment (same configuration)
however and I'm working on trying to figure out what the difference is.

If anyone else has some ideas around the following exception:

[UnauthorizedAccessException: Access is denied.]
SharedFns.WriteToEventLog(String& sString, Int16& iLogType, Int32&
iEventID) +34

I've seen the past threads on it and no one really came to a resolution.
The configuration is default and the VBScript to set the COM+ security
settings has already been run.

Cheers,
Colin

"Jeffrey R Dempsey" <jeff@jeffdempsey.com> wrote in message
news:%2337DfVeWFHA.2448@TK2MSFTNGP12.phx.gbl...
> Hello,
>
> I am pretty new to CS and SQL Server, so here goes...
>
> I have performed the installation of CS2002, and FP1, and I have a
> permissions problem. Is there a web site I can go to for errors in
> setting up CD2002 and FP1?
>
> Here are my stats:
> CS2002 Developer Edition
> SQL Server 2000 Developer edition
> Windows Server 2003
>
> I have set up the permissions per pp23 - 27 of the eBook "Integrating
> Inventory Data iwith a Catalog System" from the MS site.
>
> Questions:
> What should I put in, on page 27 for "YourSiteName"? I have accepted all
> of the defaults on the install.
>
> My SQL Server name is \\dempsey-server\store
>
> Also, when I try the "Adjust Inventory Tool" on p42, I get the following
> dialog box:
> "SQL Server does not exist or access denied" - Thanks, but that tells me
> nothing if I don't know what you're looking for...
> and then...
> "Unable to get data from database, application cannot continue"
> Then the form from p 43 flashes, and then disappears.
>
> Question:
> What is this application looking for, and what user name is it using, and
> what is it accessing?
> Are there any logs for this application?
> Is there a better book on doing all of this, like a primer? I need
> something like this:
> Step 1.
> Do this.
> If you are successful with step 1, the following appears. If not, find
> out why.
>
> I just get the feeling, with my newness to CS2002, and all of the
> applications that must be installed, this is a house of cards, and one
> wrong placement will cause the whole thing not to work. Yes, I am
> frustrated.
>
> Also,
> When I go to the http://localhost/InventoryData, I get the following:
>
> Server Error in '/InventoryData' Application.
> --------------------------------------------------------------------------------
>
> Access is 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.UnauthorizedAccessException: Access is denied.
>
> ASP.NET is not authorized to access the requested resource. Consider
> granting access rights to the resource to the ASP.NET request identity.
> ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5
> or Network Service on IIS 6) that is used if the application is not
> impersonating. If the application is impersonating via <identity
> impersonate="true"/>, the identity will be the anonymous user (typically
> IUSR_MACHINENAME) or the authenticated request user.
>
> To grant ASP.NET write access to a file, right-click the file in Explorer,
> choose "Properties" and select the Security tab. Click "Add" to add the
> appropriate user or group. Highlight the ASP.NET account, and check the
> boxes for the desired access.
>
> 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:
>
> [UnauthorizedAccessException: Access is denied.]
> SharedFns.WriteToEventLog(String& sString, Int16& iLogType, Int32&
> iEventID) +34
>
> Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeThreaded.Initialize(String
> bstrSiteName) +4215
>
> Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceCollection..ctor(String
> siteName) +278
>
> Microsoft.CommerceServer.Runtime.CommerceApplicationModule.InitializeApplication()
> +194
>
> 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
>
>
>
> --------------------------------------------------------------------------------
> Version Information: Microsoft .NET Framework Version:1.1.4322.2300;
> ASP.NET Version:1.1.4322.2300
>

Jeffrey R Dempsey

2005-05-23, 2:47 am

OK, after reading a few entries, there seems to be one thing in common... I
think I need to look at the logs....

So...

I looked at the SQL Server Logs, and found this entry:

Logon failed to user 'NT AUTHORITY\NETWORK SERVICE'

I get that twice per viewing of the web page.

Does that help isolate this?

Thanks,

JEff

"Colin Bowern" <colin.bowern@nospam.officialcommunity.com> wrote in message
news:eyb3l9jWFHA.2128@TK2MSFTNGP14.phx.gbl...
> Hi Jeffrey,
>
> I'm dealing with the same exception error that you are running into with
> regards to the event log function. I'm deploying CS2002 Standard SP3/FP1
> + SQL2000 Standard SP4 + WS2003 Standard SP1 to production. The error
> seems to be focused on the COM+ identity and permissions. I've got
> another copy of it working in a pre-production test environment (same
> configuration) however and I'm working on trying to figure out what the
> difference is.
>
> If anyone else has some ideas around the following exception:
>
> [UnauthorizedAccessException: Access is denied.]
> SharedFns.WriteToEventLog(String& sString, Int16& iLogType, Int32&
> iEventID) +34
>
> I've seen the past threads on it and no one really came to a resolution.
> The configuration is default and the VBScript to set the COM+ security
> settings has already been run.
>
> Cheers,
> Colin
>
>
> "Jeffrey R Dempsey" <jeff@jeffdempsey.com> wrote in message
> news:%2337DfVeWFHA.2448@TK2MSFTNGP12.phx.gbl...
>
>

Jeffrey R Dempsey

2005-05-23, 5:53 pm

Now, I added that user to my SQL Server aythorized users, but now I get one
failed, and one success.

Huh????

Jeff

"Jeffrey R Dempsey" <jeff@jeffdempsey.com> wrote in message
news:O%23LZvF2XFHA.2348@TK2MSFTNGP14.phx.gbl...
> OK, after reading a few entries, there seems to be one thing in common...
> I think I need to look at the logs....
>
>
> So...
>
> I looked at the SQL Server Logs, and found this entry:
>
> Logon failed to user 'NT AUTHORITY\NETWORK SERVICE'
>
> I get that twice per viewing of the web page.
>
> Does that help isolate this?
>
> Thanks,
>
> JEff
>
>
>
> "Colin Bowern" <colin.bowern@nospam.officialcommunity.com> wrote in
> message news:eyb3l9jWFHA.2128@TK2MSFTNGP14.phx.gbl...
>
>

Colin Bowern

2005-05-24, 6:02 pm

Hi Jeff,

Can you provide more information as to where you are getting this error?
Are you running this on IIS 6? What is the application pool identity
account set to?

Cheers,
Colin

"Jeffrey R Dempsey" <jeff@jeffdempsey.com> wrote in message
news:uiircK6XFHA.3096@TK2MSFTNGP15.phx.gbl...
> Now, I added that user to my SQL Server aythorized users, but now I get
> one failed, and one success.
>
> Huh????
>
> Jeff
>
> "Jeffrey R Dempsey" <jeff@jeffdempsey.com> wrote in message
> news:O%23LZvF2XFHA.2348@TK2MSFTNGP14.phx.gbl...
>
>

Jeffrey R Dempsey

2005-05-25, 2:47 am

Yes; IIS6 on Win2K3, SP1

Application pool identity?
OK, I added the 'NT AUTHORITY\NETWORK SERVICE' accesses to the databases and
now...

IT WORKS!!!!!

Thank you so much!

Jeff

"Colin Bowern" <colin.bowern@nospam.officialcommunity.com> wrote in message
news:O$v3sGJYFHA.3464@TK2MSFTNGP10.phx.gbl...
> Hi Jeff,
>
> Can you provide more information as to where you are getting this error?
> Are you running this on IIS 6? What is the application pool identity
> account set to?
>
> Cheers,
> Colin
>
> "Jeffrey R Dempsey" <jeff@jeffdempsey.com> wrote in message
> news:uiircK6XFHA.3096@TK2MSFTNGP15.phx.gbl...
>
>

Amit Bansal

2005-06-05, 5:50 pm

Hi Jeff and Colin,

I have a similar prbelm with permissions. My enviornemnt is as follows:-

Win2k3 (pls note: no service pack installed)
cs2002 developer edition with sp3 (no fp1)
sql server 2000 enterprise edition with sp4

I have successfully unpacked the retail 2002 site but fowlling are
problems:-

1. when i run http://localhost/retail2002, i get access denied. and it talks
abit aspnet machine a/c etc.

What I did:- surprisingly, i do not have "network service" a/c under users,
instead i have aspnet so i added aspnet to all the the databases with
priviliges "public" and "dbowner" - but it did not work.
under application pool indetity in iis - it shows Network service.

I dont know how to ge the site running. Please help. everything else seems
to work fine.

2. i have successfully started the business desk, by navigating to
http://localhost/retail2002bizdesk/default.asp . when i start the business
desk i get the following error.

"The application is unable to log events. if you have recently changed your
password, you must change the password for the commerce logging event object
in component services and for each commerce server winodws 2000 service. you
must then restart business desk."

- i have never changed my passwords since win2k3 installation.
- the error refers to windows2000 services, but i have win2k3
- how can restart the business desk?
- finally what is the solution to this error, thouh this error is not a
critical one, as i feel.

but the previous one is. please help me to run the retail 2002 site.

regards, amit
"Jeffrey R Dempsey" <jeff@jeffdempsey.com> wrote in message
news:ewTfRQOYFHA.796@TK2MSFTNGP10.phx.gbl...
> Yes; IIS6 on Win2K3, SP1
>
> Application pool identity?
> OK, I added the 'NT AUTHORITY\NETWORK SERVICE' accesses to the databases
and
> now...
>
> IT WORKS!!!!!
>
> Thank you so much!
>
> Jeff
>
>
> "Colin Bowern" <colin.bowern@nospam.officialcommunity.com> wrote in
message
> news:O$v3sGJYFHA.3464@TK2MSFTNGP10.phx.gbl...
Standard[vbcol=seagreen]
"Integrating[vbcol=seagreen]
accepted[vbcol=seagreen]
using,[vbcol=seagreen]
one[vbcol=seagreen]
following:[vbcol=seagreen]
>
----------[vbcol=seagreen]
if[vbcol=seagreen]
be[vbcol=seagreen]
"Add"[vbcol=seagreen]
the[vbcol=seagreen]
of[vbcol=seagreen]
below.[vbcol=seagreen]
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeThreade
d.Initialize(String[vbcol=seagreen]
Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceCollection..c
tor(String[vbcol=seagreen]
Microsoft.CommerceServer.Runtime.CommerceApplicationModule.InitializeApplica
tion()[vbcol=seagreen]
Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(HttpApplicat
ion[vbcol=seagreen]
System.Web.HttpApplicationFactory. GetNormalApplicationInstance(HttpContext
[vbcol=seagreen]
System.Web.HttpApplicationFactory. GetApplicationInstance(HttpContext[vbcol
=seagreen]
wr)[vbcol=seagreen]
>
----------[vbcol=seagreen]
>
>

Sudha Raghavan [MSFT]

2005-06-08, 5:56 pm

Hi

Here are a few things you can try:

1. Change the app pool identity to a user that has access to the MSCS
database and the site database.
2. Also give this account permissions to Read and Execute, List folder
contents, Read on %systemdrive%\WINNT\Microsoft.Net\Framework
3. Give the account full permissions to
%systemdrive%\WINNT\Microsoft.Net\Framework\v1.1.4322\Temporary ASP.NET

For the bizdesk issue, try to check if the Commerce Server Event Logger
service has been started.

Thanks
Sudha

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2005 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Have a Commerce Server “How To” question? Help is a click away at our
Chats, Newsgroups and Web logs

Chats (2nd Wednesday of the month from 11 to Noon):
http://www.msdn.microsoft.com/chats/
Public newsgroups:
http://www.microsoft.com/technet/co...r/commerce.mspx
Web logs and community:
http://www.microsoft.com/commercese...ty/default.mspx
Other resources:
http://www.microsoft.com/technet/pr...02/default.mspx
--------------------
From: "Amit Bansal" <technical@peoplewareindia.com>
References: <#37DfVeWFHA.2448@TK2MSFTNGP12.phx.gbl>
<eyb3l9jWFHA.2128@TK2MSFTNGP14.phx.gbl>
<O#LZvF2XFHA.2348@TK2MSFTNGP14.phx.gbl>
<uiircK6XFHA.3096@TK2MSFTNGP15.phx.gbl>
<O$v3sGJYFHA.3464@TK2MSFTNGP10.phx.gbl>
<ewTfRQOYFHA.796@TK2MSFTNGP10.phx.gbl>
Subject: Re: Newbie question in FP1
Date: Sun, 5 Jun 2005 23:08:59 +0530
Lines: 280
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.0
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Message-ID: <O4#FnSfaFHA.2128@TK2MSFTNGP14.phx.gbl>
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: 219.65.193.18
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:2839
X-Tomcat-NG: microsoft.public.commerceserver.general

Hi Jeff and Colin,

I have a similar prbelm with permissions. My enviornemnt is as follows:-

Win2k3 (pls note: no service pack installed)
cs2002 developer edition with sp3 (no fp1)
sql server 2000 enterprise edition with sp4

I have successfully unpacked the retail 2002 site but fowlling are
problems:-

1. when i run http://localhost/retail2002, i get access denied. and it talks
abit aspnet machine a/c etc.

What I did:- surprisingly, i do not have "network service" a/c under users,
instead i have aspnet so i added aspnet to all the the databases with
priviliges "public" and "dbowner" - but it did not work.
under application pool indetity in iis - it shows Network service.

I dont know how to ge the site running. Please help. everything else seems
to work fine.

2. i have successfully started the business desk, by navigating to
http://localhost/retail2002bizdesk/default.asp . when i start the business
desk i get the following error.

"The application is unable to log events. if you have recently changed your
password, you must change the password for the commerce logging event object
in component services and for each commerce server winodws 2000 service. you
must then restart business desk."

- i have never changed my passwords since win2k3 installation.
- the error refers to windows2000 services, but i have win2k3
- how can restart the business desk?
- finally what is the solution to this error, thouh this error is not a
critical one, as i feel.

but the previous one is. please help me to run the retail 2002 site.

regards, amit
"Jeffrey R Dempsey" <jeff@jeffdempsey.com> wrote in message
news:ewTfRQOYFHA.796@TK2MSFTNGP10.phx.gbl...
> Yes; IIS6 on Win2K3, SP1
>
> Application pool identity?
> OK, I added the 'NT AUTHORITY\NETWORK SERVICE' accesses to the databases
and
> now...
>
> IT WORKS!!!!!
>
> Thank you so much!
>
> Jeff
>
>
> "Colin Bowern" <colin.bowern@nospam.officialcommunity.com> wrote in
message
> news:O$v3sGJYFHA.3464@TK2MSFTNGP10.phx.gbl...
Standard[vbcol=seagreen]
"Integrating[vbcol=seagreen]
accepted[vbcol=seagreen]
using,[vbcol=seagreen]
one[vbcol=seagreen]
following:[vbcol=seagreen]
>
----------[vbcol=seagreen]
if[vbcol=seagreen]
be[vbcol=seagreen]
"Add"[vbcol=seagreen]
the[vbcol=seagreen]
of[vbcol=seagreen]
below.[vbcol=seagreen]
Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeThreade
d.Initialize(String[vbcol=seagreen]
Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceCollection..c
tor(String[vbcol=seagreen]
Microsoft.CommerceServer.Runtime.CommerceApplicationModule.InitializeApplica
tion()[vbcol=seagreen]
Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(HttpApplicat
ion[vbcol=seagreen]
System.Web.HttpApplicationFactory. GetNormalApplicationInstance(HttpContext
[vbcol=seagreen]
System.Web.HttpApplicationFactory. GetApplicationInstance(HttpContext[vbcol
=seagreen]
wr)[vbcol=seagreen]
>
----------[vbcol=seagreen]
>
>