After finding my problem which was at the global.aspx.cs page I now get this error.
Server Error in '/' Application.
--------------------------------------------------------------------------------

SQL Server does not exist or access denied.
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: SQL Server does not exist or access denied.

Source Error:


Line 43: SqlCommand selectCommand = BuildCommandFromMapping( cmdMap );
Line 44: AssignValuesToParameters( cmdMap, ref selectCommand, selectObject );
Line 45: selectCommand.Connection.Open();
Line 46:
Line 47: if (selectObject is PersistableObjectSet)


Source File: C:\Inetpub\wwwroot\wineshopny\CMPServices\SqlPersi stenceContainer.cs Line: 45

Stack Trace:


[SqlException: SQL Server does not exist or access denied.]
   System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) +474
   System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
   System.Data.SqlClient.SqlConnection.Open() +383
   WS.CMPServices.SqlPersistenceContainer.Select(Pers istableObject selectObject) in C:\Inetpub\wwwroot\wineshopny\CMPServices\SqlPersi stenceContainer.cs:45

[Exception: Persistance (Select) Failed for PersistableObject]
   WS.CMPServices.SqlPersistenceContainer.Select(Pers istableObject selectObject) in C:\Inetpub\wwwroot\wineshopny\CMPServices\SqlPersi stenceContainer.cs:66
   WS.Web.ProductCatalog.ProductCatalog.GetChildCateg ories(Int32 categoryId) in C:\Inetpub\wwwroot\wineshopny\ProductCatalog\Produ ctCatalog.cs:37
   WS.Web.ProductCatalog.ProductCatalog.GetCategories () in C:\Inetpub\wwwroot\wineshopny\ProductCatalog\Produ ctCatalog.cs:23
   wineshopny.Global.Application_Start(Object sender, EventArgs e) in c:\inetpub\wwwroot\wineshopny\wineshopny\Global.as ax.cs:37




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

I checked the web config file up and down I'm sure I put in the correct server name and password. the site is on a live web server with a SQL server installed on it I don't understand why it doesn't want to work.

Brett G. Murphy