Web Site Administration Tool

[TiltingCode]

This is using ASP.NET 3.5 on a Windows 7 Professional OS. I'm not using the internet yet, just my laptop.

When I click on the Security tab of the Web Site Administration Tool I get the following message:

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

The following message may help in diagnosing the problem: [b]Unable to connect to SQL Server database.[/b]

I followed the directions to choose a new data store and apparently it gave me AspNetSqlProvider which does not work either. I clicked the Test link and got the below 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 do have SQL server 2005 installed but according to what I understand in the book it shouldn't matter since MDF file is supposed to be created.

Can someone help me get beyond this issue? I tried Googling but no help.

Any ideas to get me on my feet again?

 

[jbenson001]

It's been a while since I dealt with this, but if you are using the provider model, you need to install the database that the UI needs. There is a command line utility for this. You will have to look that up. Then be sure you are pointing to that DB and not your local instance of SQL 2005