hey everyone, ive created a site which works locally on my computer, but im now trying to put it on a server.

im 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)
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: 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)

Source Error:

Line 82: catch (Exception ex)
Line 83: {
Line 84: throw ex;
Line 85: }
Line 86: finally

Source File: d:\home\Default\*******\htdocs\App_Code\connectionAccess.cs Line: 84

Stack Trace:

[SqlException (0x80131904): 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)]
connectionAccess.ExecuteNonQuery(DbCommand command) in d:\home\Default\*******\htdocs\App_Code\connectionAccess.cs:84
dataAccess.countEvent(Int32& count) in d:\home\Default\*******\htdocs\App_Code\dataAccess.cs:223
frontendpolitburo_home.Page_Load(Object sender, EventArgs e) in d:\home\Default\*******\htdocs\home.aspx.cs:19
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061


starred out the website, anyways. ive tried everything that googling says to do - e.g changing it to local/remote connections on the server etc. anyone have any idea at all? im using this as my connection string at the moment

<add name="siteDBConnectionString" connectionString="Server=EVOLUTION99\SQLEXPRESS;;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=siteDB;Data Source=siteDB" providerName="System.Data.SqlClient" />

i have no absolutely no idea how to fix this in all honesty, i spent a good 4 hours on it yesterday and go no where. anyone have any ideas/solutions?

thanks in advance