SQLExpress - Remote Access Trouble When Publishing A Site

Hi all,

I followed this excellent tutorial (from Microsoft) about creating and using a SQLExpress db table internal to your website:

http://www.asp.net/learn/videos/video-08.aspx

and the site I created works just fine - locally. When I publish to my web host provider I get this error:

[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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]

My web host provider supports .NET 2.0 but doesn't support MS SQL Server. But that should matter - right? Because I'm putting the db instance right in the website?

I did a search and followed some of the advice:

I went into the SQL Server Surface Area Config Mgr and set SQLExpress for local and remote connections and rebooted/republished. I also have SQL Server 2005 installed as a separate entity (if that makes a difference).

I still get the above error. This is the connection string from the web.config:

<connectionStrings><add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Customers.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

</connectionStrings>And this is the call from the markup:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

SelectCommand="SELECT * FROM [Customer]"></asp:SqlDataSource>

Does any know the fix for this? 

Thanking you in advance

Pat