I designed a shopping cart site based on the Wrox United site. Everything works fine locally, but when I publish to the server, I get the following error when trying to view the shopping cart page or any page that references the Profile.Cart:

System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

It has nothing to do with the database or connection strings, because I can view the master/detail pages just fine. I am working in VB. Thanks.

Hi Disturbed Buddha,

I'm not sure exactly what \ how things aren't working, but have a look at the solution part of http://blogs.ipona.com/dan/archive/2...WoesPart1.aspx to make perfectly sure that it's not a connection issue on one side or another.

If you switch on custom errors in your web.config file, you should get some more information about the error beyond this generic information. Let me know how you get on.

dan

Dan Maharry
Read the feed at http://feeds.feedburner.com/dansarchive