Hello,

I am new to MS Commerce (and Microsoft stuff in general). I am trying to set
up the retail solution site. I am using Commerce Server 2002 and SQL Server
2000 Desktop Engine, both running on the local machine. The Business Desk
works, but when I go to http://localhost/retail to see the site I get the
following message:

Error Type:
Microsoft Commerce Configuration (0x80040E4D)
Login failed for user 'SYR-MBOEDICKER\IUSR_SYR-MBOEDICKER'.
SiteConfig:Initialize
/retail2/include/global_siteconfig_lib.asp, line 195

I am not sure what it can't log in to, but I am guessing it's the database.
Maybe the user that IIS runs as (IUSR_SYR-MBOEDICKER) does not have
sufficient access to the database?

I tried using OSQL to grant IUSR_SYR-MBOEDICKER access to the database, but
that didn't help.

Any suggestions of things I should verify?

Thanks.

[ Post a follow-up to this message ]

Expand the 'Logins' folder within the SQL enterprise manager and check
whether the account you're running IIS under is in there. If it isn't, whack
it in there and give it the appropriate table access and you should be
laughing.

Cheers
Scott

"Matthew M. Boedicker" wrote:

> Hello,
>
> I am new to MS Commerce (and Microsoft stuff in general). I am trying to s
et
> up the retail solution site. I am using Commerce Server 2002 and SQL Serve
r
> 2000 Desktop Engine, both running on the local machine. The Business Desk
> works, but when I go to http://localhost/retail to see the site I get the
> following message:
>
> Error Type:
> Microsoft Commerce Configuration (0x80040E4D)
> Login failed for user 'SYR-MBOEDICKER\IUSR_SYR-MBOEDICKER'.
> SiteConfig:Initialize
> /retail2/include/global_siteconfig_lib.asp, line 195
>
> I am not sure what it can't log in to, but I am guessing it's the database
.
> Maybe the user that IIS runs as (IUSR_SYR-MBOEDICKER) does not have
> sufficient access to the database?
>
> I tried using OSQL to grant IUSR_SYR-MBOEDICKER access to the database, bu
t
> that didn't help.
>
> Any suggestions of things I should verify?
>
> Thanks.

[ Post a follow-up to this message ]

You should also look at the Commerce Deployment guide which has
instructions to set your Windows accounts
--------------------
Thread-Topic: login failed for retail solution site
thread-index: AcSbQ6yBCckH23/ZSzyONmyYc/2ENQ==
X-WBNR-Posting-Host: 80.3.160.11
From: "examnotes" <Scott@discussions.microsoft.com>
References:  <55752A99-DC20-4101-9D24-BECB5BC0A1F9@microsoft.com>
Subject: RE: login failed for retail solution site
Date: Wed, 15 Sep 2004 09:47:23 -0700
Lines: 34
Message-ID: <F9683CA2-A2DA-461E-87C7-65AFC870860E@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.1.29
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.commerceserver.general:14772
X-Tomcat-NG: microsoft.public.commerceserver.general

Expand the 'Logins' folder within the SQL enterprise manager and check
whether the account you're running IIS under is in there. If it isn't,
whack
it in there and give it the appropriate table access and you should be
laughing.

Cheers
Scott

"Matthew M. Boedicker" wrote:

> Hello,
>
> I am new to MS Commerce (and Microsoft stuff in general). I am trying to
set
> up the retail solution site. I am using Commerce Server 2002 and SQL
Server
> 2000 Desktop Engine, both running on the local machine. The Business Desk
> works, but when I go to http://localhost/retail to see the site I get the
> following message:
>
> Error Type:
> Microsoft Commerce Configuration (0x80040E4D)
> Login failed for user 'SYR-MBOEDICKER\IUSR_SYR-MBOEDICKER'.
> SiteConfig:Initialize
> /retail2/include/global_siteconfig_lib.asp, line 195
>
> I am not sure what it can't log in to, but I am guessing it's the
database.
> Maybe the user that IIS runs as (IUSR_SYR-MBOEDICKER) does not have
> sufficient access to the database?
>
> I tried using OSQL to grant IUSR_SYR-MBOEDICKER access to the database,
but
> that didn't help.
>
> Any suggestions of things I should verify?
>
> Thanks.


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.  Thanks

[ Post a follow-up to this message ]