Hello,

I just wanted to share my trials on installing.

I have Win2K/SP4/ADInstalled, Exchange, IIS5, ASP.NET 1.1, MSDE SP3a.

I can query and communicate with DB via MSDE Query to my server name or . but never to localhost and I'm not about to change my server name!

I installed Locally to remote with IIS support, I created and populated Commerce DB with permissions for remote (permissions for local would not execute without errors no matter which valid account I used)

This is what I recieved trying to bring up the site:

Server Error in '/CommerceCSSDK' Application.
--------------------------------------------------------------------------------

Login failed for user 'ServerName\UserAccount'.
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.Data.SqlClient.SqlException: Login failed for user 'ServerName\UserAccount'.

Source Error:


Line 28: ASPNET.StarterKit.Commerce.ProductsDB products = new ASPNET.StarterKit.Commerce.ProductsDB();
Line 29:
Line 30: MyList.DataSource = products.GetProductCategories();
Line 31: MyList.DataBind();
Line 32: }


Source File: C:\Program Files\ASP.NET Starter Kits\ASP.NET Commerce (CSSDK)\CommerceCSSDK\_Menu.ascx Line: 30

Stack Trace:


[SqlException: Login failed for user 'ServerName\UserAccount'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASPNET.StarterKit.Commerce.ProductsDB.GetProductCategories()
ASP._Menu_ascx.Page_Load(Object sender, EventArgs e) in C:\Program Files\ASP.NET Starter Kits\ASP.NET Commerce (CSSDK)\CommerceCSSDK\_Menu.ascx:30
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +731




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

I can communicate with the DB via input and retrieval but the web pages don't seem to be communicating with MSDE because of permissions?

ANYONE HELP

hi
i get a very similar error

Error de servidor en la aplicación '/CommerceVBVS'.
--------------------------------------------------------------------------------

Error de inicio de sesión del usuario 'NT AUTHORITY\Servicio de red'.
Descripción: Excepción no controlada al ejecutar la solicitud Web actual. Revise el seguimiento de la pila para obtener más información acerca del error y dónde se originó en el código.

Detalles de la excepción: System.Data.SqlClient.SqlException: Error de inicio de sesión del usuario 'NT AUTHORITY\Servicio de red'.

Error de código fuente:

Se ha generado una excepción no controlada durante la ejecución de la solicitud Web actual. La información sobre el origen y la ubicación de la excepción pueden identificarse utilizando la excepción del seguimiento de la pila siguiente.

Seguimiento de la pila:


[SqlException: Error de inicio de sesión del usuario 'NT AUTHORITY\Servicio de red'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASPNET.StarterKit.Commerce.ASPNET.StarterKit.Commerce.ProductsDB.GetProductCategories()
ASPNET.StarterKit.Commerce.C_Menu.Page_Load(Object sender, EventArgs e)
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +731


can someone please help us, or point us where we can get some info to troubleshoot this instalations errors

The only way I found around this was to reference my machine name in the web.config file. Then it connects fine.

The line in the web.config should look like this:
<add key="ConnectionString" value="server=myServerName;database=Commerce;uid=CommerceUser;pwd=CommerceUser;" />