ASP.NET membership data storage issue
<p>I have created a sample web application in Visual Studio 2010. It stores Membership data(users, roles etc) in a .mdf file in App_data folder. But I don't wanna do this. I wanna store data in SQL server database. </p>

<p>For that I Google a lot but could not find solution. Here is what I am doing so for. First I create application then by using Web configuration tool I set users, roles etc and when hit provider tab it throws following error:</p>

<p><strong><code>Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.</code></strong></p>

<p>Then I execute <code>aspnet_regsql</code> utility and created a database in SQL Server and again open web configuration tool but error is same, no change. </p>

<p>Please guide either i am going in right direction or not. If right then how can I store data in <code>aspnet_regsql</code> generated  SQL server database? </p>

<p>Note that I am using .NET framework 4, SQL server 2008 R2, Visual studio 2010. In fact I was expecting that there will be connection string in <code>web.config</code> file just like other data driven controls do. But no entries go in <code>web.config</code> file.</p>
