montagueloc
02-10-2006, 08:58 AM
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_sqlse rverpassword" providerName="System.Data.SqlClient"/>
</connectionStrings>
It worked for me, be aware that your data source, inital catalog, username etc may be different from mine.
<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_sqlse rverpassword" providerName="System.Data.SqlClient"/>
</connectionStrings>
It worked for me, be aware that your data source, inital catalog, username etc may be different from mine.