Last post Aug 31, 2010 07:47 PM by am.dee
Jun 25, 2009 11:33 PM|Gusto001|LINK
Hi, I am new to VWD and i am trying to use the Provider Configuration in the ASP.net Web Site Administration tool to configure my Web site management data.
When ever i select the "Select a single provider for all site management data" there is only one provider "AspNetSqlProvider".
When i select "test" it give me the following error 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."
I have the aspnet_regsql to create a DB, my IIS is already installed and enable but the VWD ASP.net Web Site Administration tool refuse to connect to my SQL DB.
What may be the problem and how can i rectify it.
Visual Web Developer 2005 Express
Jun 26, 2009 04:48 AM|albarossa|LINK
I'm not familiar with VWD, try this link:
Jul 01, 2009 03:39 AM|Thomas Sun – MSFT|LINK
By default, ASP.NET Web Site Administration tool uses connection string named "LocalSqlServer" to connect database. It is "data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" by
In your case, you created your own database using aspnet_regsql. Please make sure this connection string is correct. You can configure it in your web.config.
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="your connection string" providerName="System.Data.SqlClient" />
I look forward to receiving your test results.
Aug 31, 2010 07:47 PM|am.dee|LINK
It worked for me. Thank u..