Upload a Sql website to a host server

Hi

I have built a site in Visual Web developer Express 2005. it works fine on my local machine but when I load it up to the server I get the following error message:

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)

My connectionstring in my web config file:

<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"

providerName="System.Data.SqlClient" />

I have enabled remote connections with TCP/IP only on my sql express SAC

I.ve tried hours to resolve this problem, Please help.

Yes I did

But it still does not work

I just want to clarify.

It works fine on my local machine but I get the error if I upload it to the server and then try to run it. Will these changes make any diffeence with that

OK

I verified that the SQl Server Browser is running under the SAC panel, then build and uploaded the application again.

I get the same error message

Well I am not to sure about that.

On the SAC window

under SQL server browser there is one service listed :

SQLBrowser

It does not say anything about remote.Under SQLEXPRESS remote connetions is set to local and remote with TCP/IP

Well indeed

Go daddy does not support Express on their shared hosting accounts. What a pain...

Thank you very very much for you help.

THANKS ! That  helped a lot.

I compiled a sql script(with the data publihing wizard) and ran it at my hosts database quiry to import it to the database but got the following error

Line 5: Incorrect syntax near 'ROLE'.

/****** Object:  Role [aspnet_Membership_BasicAccess]    Script Date: 02/01/2007 22:45:36 ******/
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Membership_BasicAccess')
BEGIN
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'aspnet_Membership_BasicAccess' AND type = 'R')
CREATE ROLE [aspnet_Membership_BasicAccess] AUTHORIZATION [dbo]

END

Can anyone help 1