I have an application I wrote using ASP.NET 2.0 book as a guide for a shopping cart function. I have everything working great on my local system using SQL 2005 Express. When I move the app to an IIS 6.0 Web Server with SQL 2005 Express installed I get the following error.

Line 103: Public Overridable Property Cart() As Wrox.Commerce.ShoppingCart
Line 104: Get
Line 105: Return
CType(Me.GetPropertyValue("Cart"),Wrox.Commerce.Sh oppingCart)
Line 106: End Get
Line 107: Set

It has some comments up top about not being able to establish a connection
to the SQL Express Database. I have made the changes to allow TCP/IP and
Named-Pipes

The App has to be connecting to the database because it displays grid views
during the order process.

The Database is located in the App Data folder

IIS is set to Integrated Authentication and configured as a Web Application.
web.config is setup to impersonate

<authentication mode="Windows"/>
      <anonymousIdentification enabled="true"/>
      <identity impersonate="true"/>

Can someone please tell me what is wrong.

thanks.....



IronSights