I am using Visual Studio Express 2010 and SQL Server 2008 Express.
When I use the "Web Site Administration Tool" and click on "Security" I get the message "Unable to connect to SQL Server database." I then click on "Choose Data Store". I see "Your application is currently configured to use the provider: AspNetSqlProvider". I click on "Select a single provider for all site management data". I then click "Test".
I then get, "Provider Management" "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."
I have run the aspnet_regsql utility and configured my database and copied it to my app_data folder. Here are the contents of my web.config file for the site:
<add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;User Instance=True;AttachDBFilename=|DataDirectory|Database=AspNetServices;Uid=AspNetServicesUser;Pwd=sitepassword"/>
View Complete Post