Chapter 18 - Can't Run WAT
I'm working through the first Try It Out (p. 586). I've gotten to step 3, where I'm supposed to start working through the WAT. When I click on the Security tab, I get an error 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: Unable to connect to SQL Server database. "
There is a button in the corner that says "Choose Data Store." When I click that button, I get this message:
"Use this page to configure how Web site management data such as membership is stored. You can use a single provider for all the management data for your site or you can specify a different provider for each feature.
Your application is currently configured to use the provider: AspNetSqlProvider
Select a single provider for all site management data
Select a different provider for each feature (advanced) "
When I click on single provider, I only have one option (AspNetSqlProvider), but when I click the Test link, I get this:
"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 no idea what I'm supposed to do now. I have SQL Server 2005 Developer's Edition installed as well as VS2005. Any help would be appreciated.
Thank you.
|