Hi,

I have just to install Commerce Server 2006 Beta1.

When I go to starterSite I have this message :

Cannot open database "MSCS_Admin" requested by the login. The login
failed.
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: Cannot
open database "MSCS_Admin" requested by the login. The login failed.


In sql 2005, I add User machineName\CSWPA  in Db_owner on MSCS_Admin,
MSCS_CatalogScratch and DirectMailer.

[ Post a follow-up to this message ]

Can you open up SQL Profiler and do a quick trace to see what is happening
on the SQL end?

Cheers,
Colin

> Hi,
>
> I have just to install Commerce Server 2006 Beta1.
>
> When I go to starterSite I have this message :
>
> Cannot open database "MSCS_Admin" requested by the login. The login
> failed.
> 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: Cannot
> open database "MSCS_Admin" requested by the login. The login failed.
>
> In sql 2005, I add User machineName\CSWPA  in Db_owner on MSCS_Admin,
> MSCS_CatalogScratch and DirectMailer.
>

[ Post a follow-up to this message ]

Hi,

The error is coming most likely because your IIS site is still associated
with the default worker process which is running under the Network Service
account. What you can do is

Change the Identity of the default app pool to configurable
AND
Give the group IIS_WPG read access to the MSCS_Admin DB

--
Ravi Shankar


"degrem_m" wrote:

> Hi,
>
> I have just to install Commerce Server 2006 Beta1.
>
> When I go to starterSite I have this message :
>
> Cannot open database "MSCS_Admin" requested by the login. The login
> failed.
> 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: Cannot
> open database "MSCS_Admin" requested by the login. The login failed.
>
>
> In sql 2005, I add User machineName\CSWPA  in Db_owner on MSCS_Admin,
> MSCS_CatalogScratch and DirectMailer.
>
>

[ Post a follow-up to this message ]