Connection String Example to use SQL2000 or SQL2005 instead of SQLExpress

After configuring your remote SQL database for membership use the following connection string to use membership services in Visual Studio. Edit the web.config file as follows.

<connectionStrings>
<remove name="LocalSqlServer"/>
<clear/>
<add name="LocalSqlServer" connectionString="Data Source=sql2k502.discountasp.net;Integrated Security=false;Initial Catalog=SQL2005_215582_members;User ID=SQL2005_215582_members_user;Password=your_sqlserverpassword" providerName="System.Data.SqlClient"/>
</connectionStrings>

It worked for me, be aware that your data source, inital catalog, username etc may be different from mine.