we tried to follow a tutorial in the commerce server documentation for
visual studio.net developers (adaption of user profiling, setting up a login
and logout page) but we are constantly receiving the attached error. we are
working with an evaluation version of commerce server 2002. we have already
two other applications (the retail template and its bizdesk) running on the
same (default) website.

error:


Login failed for user 'MYSERVER\ASPNET'.
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: Login failed
for user 'MYSERVER\ASPNET'.

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 (0x80040e4d): Login failed for user 'MYSERVER\ASPNET'.]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String
Password, Int32 Options) +0
SharedFns.ReadSQLDbLocale(String& strAdminConn)
SharedFns.SQLGetConnStr()

Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeThreade
d.SQLGetConnection()

Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeThreade
d.Initialize(String bstrSiteName)

[CommerceException: Login failed for user 'MYSERVER\ASPNET'.]
SharedFns.ThrowCommerceException(String message, Exception inner)

Microsoft.CommerceServer.Interop.Configuration.SiteConfigReadOnlyFreeThreade
d.Initialize(String bstrSiteName)

Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceCollection..c
tor(String siteName)

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.InitializeApplica
tion()

Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(HttpApplicat
ion appInstance)
System.Web.HttpApplication.InitModules()
System.Web.HttpApplication.InitInternal(HttpContext context,
HttpApplicationState state, MethodInfo[] handlers)

System.Web.HttpApplicationFactory. GetNormalApplicationInstance(HttpContext

context)
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
context) +256
System.Web.HttpRuntime. ProcessRequestInternal(HttpWorkerRequest
 wr) +414

[ Post a follow-up to this message ]

The user MyServer\Aspnet should be given permissions to the commerce
databases
You should go through the "Secure Deployment Guide" for permissions
necessary for the commerce databases


Thanks
Vinayak Tadas
Microsoft

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


"Marc Bopel" <bopel@bluewin.ch> wrote in message
news:ufDvxy9JEHA.2452@TK2MSFTNGP09.phx.gbl...
> we tried to follow a tutorial in the commerce server documentation for
> visual studio.net developers (adaption of user profiling, setting up a
login
> and logout page) but we are constantly receiving the attached error. we
are
> working with an evaluation version of commerce server 2002. we have
already
> two other applications (the retail template and its bizdesk) running on
the
> same (default) website.
>
> error:
>
>
> Login failed for user 'MYSERVER\ASPNET'.
> 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: Login
failed
> for user 'MYSERVER\ASPNET'.
>
> 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 (0x80040e4d): Login failed for user 'MYSERVER\ASPNET'.]
>    ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
String
> Password, Int32 Options) +0
>    SharedFns.ReadSQLDbLocale(String& strAdminConn)
>    SharedFns.SQLGetConnStr()
>
>
Microsoft.CommerceServer.Interop.Configuration. SiteConfigReadOnlyFreeThreade
> d.SQLGetConnection()
>
>
Microsoft.CommerceServer.Interop.Configuration. SiteConfigReadOnlyFreeThreade
> d.Initialize(String bstrSiteName)
>
> [CommerceException: Login failed for user 'MYSERVER\ASPNET'.]
>    SharedFns.ThrowCommerceException(String message, Exception inner)
>
>
Microsoft.CommerceServer.Interop.Configuration. SiteConfigReadOnlyFreeThreade
> d.Initialize(String bstrSiteName)
>
>
Microsoft.CommerceServer.Runtime.Configuration.CommerceResourceCollection..c
> tor(String siteName)
>
>
Microsoft.CommerceServer.Runtime.CommerceApplicationModule.InitializeApplica
> tion()
>
>
Microsoft.CommerceServer.Runtime.CommerceApplicationModule.Init(HttpApplicat
> ion appInstance)
>    System.Web.HttpApplication.InitModules()
>    System.Web.HttpApplication.InitInternal(HttpContext context,
> HttpApplicationState state, MethodInfo[] handlers)
>
> System.Web.HttpApplicationFactory. GetNormalApplicationInstance(HttpContext

> context)
>    System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
> context) +256
>    System.Web.HttpRuntime. ProcessRequestInternal(HttpWorkerRequest
 wr)
+414
>
>
>
>
>

[ Post a follow-up to this message ]

I'm on a client assignment which requires the setup and deployment of Commer
ce Server.  I am getting this error and the answer posted does not work.  I 
have added the ASPNET account to both the new site's databases as well as th
e commerce server databases

[ Post a follow-up to this message ]

You need to add the ASPNET user to the MSCS_Admin database.
--------------------
Thread-Topic: System.Runtime.InteropServices.COMException
thread-index: AcRPwtFkOW991oluRlmFQr06/yaxXw==
X-WN-Post: microsoft.public.commerceserver.general
From: "examnotes" <anonymous@discussions.microsoft.com>
References:  <ufDvxy9JEHA.2452@TK2MSFTNGP09.phx.gbl>
<e1RkfgKKEHA.3380@TK2MSFTNGP09.phx.gbl>
Subject: Re: System.Runtime.InteropServices.COMException
Date: Fri, 11 Jun 2004 07:46:02 -0700
Lines: 5
Message-ID: <E15D42AC-33BB-4744-AFD3-6DA611043099@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
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:13973
NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
X-Tomcat-NG: microsoft.public.commerceserver.general

I'm on a client assignment which requires the setup and deployment of
Commerce Server.  I am getting this error and the answer posted does not
work.  I have added the ASPNET account to both the new site's databases as
well as the commerce server databases.

What else could be causing this problem?

What is the answer to this problem?


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 ]