I need help regarding connection of my asp.net application with sql server 2005 developer edition by the instance of SQLSERVERDEV.

I have freshly installed my pc installed Visual Studio after SQL SERVER installation. When I run the ASP.NET Configuration. I click on Security to define roles and users but it doesn't connect to database and send me to the provider page. When I click on the Test in front of AspNetSqlProvider It gives me 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.

I ran the aspnet_regsql wizard also and it configured the aspnetdb database in SQL Server 2005 but still I am getting the same error. Please somebody help me I am stuck here!

Thanks a million in advance.

Since you have a fresh installation, it probably literally does not have the aspnetdb.mdf file that it's looking for. It's created the first time you add a user. If I remember we got around this by making a Create user page for the application. Then ran it locally, and created one user. That initiated all of the database building for the application.

-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.

When the database gets generated automatically, it means you're using a local SQL Server Express edition, not the Developer edition.

Did you also configure web.config to talk to the new database instead?

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004