Error: CommerceServer2002's Administration database is not accessible, acces
s
to site is denied temporarily.

Webserver is server2003 box running commerce server2002. SQL is server 2003
box running SQLserver 2000 sp4.

Sql box lives in top level domain, lets call it internet.parent.com

Commerce server lives in child domain, lets call it child.internet.parent.co
m

Getting this error on webpages even though the commerce server admin
database connection validates.

I saw a document that advised to add an IIS_WPG (IIS worker process group)
to the SQL login but can't figure it out.

Any help out there?
Paulie

[ Post a follow-up to this message ]

The Identity running the CS2002 web app (Application Pool) must have certain
access to the Commerce Server databases. I usually run my CS App Pool under
a service account and grant that domain account the correct rights to the CS
databases. The installation instructions and CS2002 help file explains how
to do this.

--
Jeff Lynch
"Ramblings From A [Microsoft] Connected Universe"
http://codebetter.com/blogs/jeff.lynch


"PaulieS" <PaulieS@discussions.microsoft.com> wrote in message
news:E1FBA970-0F51-4F1B-B138-52231CA0CF3E@microsoft.com...
> Error: CommerceServer2002's Administration database is not accessible,
> access
> to site is denied temporarily.
>
> Webserver is server2003 box running commerce server2002. SQL is server
> 2003
> box running SQLserver 2000 sp4.
>
> Sql box lives in top level domain, lets call it internet.parent.com
>
> Commerce server lives in child domain, lets call it
> child.internet.parent.com
>
> Getting this error on webpages even though the commerce server admin
> database connection validates.
>
> I saw a document that advised to add an IIS_WPG (IIS worker process group)
> to the SQL login but can't figure it out.
>
> Any help out there?
> Paulie

[ Post a follow-up to this message ]

Hi Pauline,

What I'd have done in such a domain scenario is as follows
1. Create the CS Service Account in the parent domain
2. Create an account (eg: IUSER_WEBDOMAIN) in the parent domain
3. Create a Security Group IIS_WPG (Global) in the Parent
4. Make IUSER_WEBDOMAIN a member of this group
5. Give this group the permissions at the SQL Level
6. Install CS using the CS service a/c in the child domain
7. On the web server add the (parent\IIS_WPG) group to the child\IIS_WPG
group
8. Under IIS create a New App Pool with CS Service A/c as the identity
9. Run your Main Site application under this
10. On the default pool change the identity to DOMAIN\IUSER_WEBDOMAIN
11. Run the other Site applications (BizDesk, CatalogWebService,
MarketingWebService, B2BSite) under default pool.

Hope this helps.
--
Ravi Shankar


"PaulieS" wrote:

> Error: CommerceServer2002's Administration database is not accessible, acc
ess
> to site is denied temporarily.
>
> Webserver is server2003 box running commerce server2002. SQL is server 200
3
> box running SQLserver 2000 sp4.
>
> Sql box lives in top level domain, lets call it internet.parent.com
>
> Commerce server lives in child domain, lets call it child.internet.parent.
com
>
> Getting this error on webpages even though the commerce server admin
> database connection validates.
>
> I saw a document that advised to add an IIS_WPG (IIS worker process group)
> to the SQL login but can't figure it out.
>
> Any help out there?
> Paulie

[ Post a follow-up to this message ]