Alright, I just deployed to my "live" hosting server.  But I have a severe problem.   I am getting the following error

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

The thing is, I know the database connection is fine because I can login as host/admin no problem.  I can see and change the settings no problem.  My custom module works fine. Only the core modules I have added (Events, Forum, Announcements) show this error.  My connection strings are below (I've replaced all the real values, but you get the idea)  Help if you can!

<connectionStrings>
    <!-- Connection String for SQL Server 2000/2005-->
    <add name="SiteSqlServer" connectionString="Server=servername;Database=databasename;uid=username;pwd=password;" providerName="System.Data.SqlClient" />
</connectionStrings>

<appSettings>
    <!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules-->
    <add key="SiteSqlServer" value="Server=servername;Database=databasename;uid=username;pwd=password;" />

 

Thanks for the help.  It turned out my connection string was slightly different for the appsettings and connectionstrings sections.  Fixed that up and all is good.  Thanks!