I am following the lesson from here:
( about 4 min into it ).
When I click on "Website" and then ASP.net Configuration, and then click
Security I get an error.
There is a problem with your selected data store. This can be caused by an
invalid server name or credentials, or by insufficient permission. It can
also be caused by the role manager feature not being enabled. Click the
button below to be redirected to a page where you can choose a new data
The following message may help in diagnosing the problem: Unable to
to SQL Server database.
I now click on the "Providers" tab and click on
"Select a single provider for all site management data"
Then I click on "Test" beside the AspNetSqlProvider
and it Fails
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
I have already gone into dos and ran: aspnet_regsql to create the aspnetdb
-This worked properly -I have the table and all the fields there. I have
confirmed this through the management studio.
I can go into my server management studio and I can see the file.
My server instance is the default one added "sqlexpress".
I have set my server instance to accept remote connections with named
and tcp ip
( my service is running )
I have no issues connecting to datafiles with my server explorer.
What am I missing for this setup?
At first I thought it was my development server issue so i fully
that and re-installed the sql express version thinking that was it.
I am now fully stuck.