|
Home > Archive > Commerce Server General > September 2004 > login failed for retail solution site
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
login failed for retail solution site
|
|
| Matthew M. Boedicker 2004-09-10, 5:51 pm |
| 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.
| |
| Scott 2004-09-15, 11:15 am |
| 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.
| |
| Vinayak Tadas[MSFT] 2004-09-15, 5:49 pm |
| 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: "=?Utf-8?B?U2NvdHQ=?=" <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
|
|
|
|
|