I have aspnetdb.mdf database but not able to create a provider in WAT
Posted on 2011-03-18
Hi, I'm developing using asp.net 3.5, C# on Windows 7 home premium PC. I have sql 2005 express and using it for asp.net security because it automatically created the aspnet_users database for me. Unfortuneately, prior to this I also had installed 2 other instances of sql, sql2008 and sql advanced 2008. I have stop these 2 instances services.
I am able to create users and roles using WAT. I have also successfully log in using this. I can see the aspnetdb.mdf database from VS2008's Server Explorer.
I start WAT, Provider and the screen:
Your application is currently configured to use the provider: AspNetSqlProvider
Select a single provider for all site management data
Select a different provider for each feature (advanced)
I then click the Test in the next screen.
I got the next message
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.