Hi,

I have finally manage to successfully run aspnet_regsql and there are no connection error. However when I tried to set up a Provider using ASP.net Web Site Administration Tool and tested AspNetSqlProvider, it gives the following error:

"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."

Please advise.

Thanks.

Here are the steps I took to get it to work correctly, hope it helps you.

1.) Created & Configured the "aspnetdb" database on the SQL Server:


a.) Confirmed SQL server was running, from the command line "sqlcmd -S./SQLEXPRESS" and get the "1>" prompt, type "exit" to exit sqlcmd prompt.
or use Services MMC, the Service may be named something like 'SQL Server(InstanceName)', or "SQl Server (SQLEXPRESS)"

b.) Ran the command line utility aspnet_regsql, which initiated the GUI Wizard, accepted all defaults for the database creation.
Confirmed the database "aspnetdb" was created.

c.) Used the SQL Server Configuration Manger to set the Network & Client Protocal settings
Disabled "Share Memeory" Protocal, another web site tip had indicated the the "Share Memory" protocal was problematic. In case you

Client Protocals "TCP/IP" & "Named Pipes" set to enabled

Moved Client Protocals order to 1 for "TCP/IP"

d.) Added and gave full acces to "NETWORK SERVICE" & "ASPNET" SQL logins to the "aspnetdb" database that was created by the aspent_regsql utility

e.) Enabled/Started the SQL Browser service.

    Restarted SQL Server service.

2.)

Edited the Web.config file

Web.config snippet
----------------------------
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
    <appSettings/>
    <connectionStrings>
  <remove name="LocalSqlServer" />
  <add name="LocalSqlServer" connectionString="data source=MySQLServerName\MySQLSvrInstanceName;Integr ated Security=True;Database=aspnetdb;"
   providerName="System.Data.SqlClient" />
----------------------------

Specifically
connectionString="data source=MySQLServerName\MySQLSvrInstanceName;Integr ated Security=True;Database=aspnetdb;"

If you do not have multiple SQL instance installed on you machine, then "MySQLServerName\MySQLSvrInstanceName" would not apply
could be server possibilities like "./SQLEXPRESS", "(local)", , "ServerName" or "."

3.) Used the Internet Information Services MMC

a.) Open the properties for the Web application and on the "ASP.NET" tab confirmed ASP.NET version set to 2.0

b.) Restarted IIS

b.) Restart IIS.

4.) Opened the website project with VS 2005, and selected "ASP.NET Configuration" from Website menu.

Confimed website connectivity to database by going to the "Provider Configuation" in the ASP.NET Web Site Administration Tool,
selecting "Select a single provider for all site management data" and then click the "Test" link and getting
the "Successfully established a connection to the database." confirmation.

This really helped me a lot..

i hope to find simple postings like this one here.

love the quick Tutorials.:D

Thanks for the fix me up, i've spent hours trying to sort this problem out, your post is the all in 1 solution. Thanks again...

Hi, this article really helped a lot! I did all the steps and it worked perfectly on my local. However, I would now like the web admin tool to connect to a remote server. I just changed my connectionString to this:

<connectionStrings>
    <remove name="LocalSqlServer"/>
    <add name="LocalSqlServer" connectionString="Data Source=ServerName;Initial Catalog=aspnetdb;Integrated Security=SPPI; User ID= UserName; Password= Password" providerName="System.Data.SqlClient"/>

</connectionStrings>

Is there something wrong with my code? Do I still need to do something elese? By the way, I'm going to connect to a remote server that uses SQL 2005. I've already setup the aspnetdb on the remote server. Can somebody PLEASE help me? :( PLEASE HELP!