Hello all,
OK, I'm stumped. When I create a new web page and add a login control, I set the format and then choose Administer Site. When I click on Security in WSAT, I get an error that it can't reach the SQL Server. I tried it on two XP machines with the same result. In the App_Data folder, it never created the database.
I then tried the same thing on a Vista machine running VWD 2005 Express, and it created the database and went right into the security screen. I can also see the MDF in App_Data.
Is there something wrong with VWD 2008 or did something change and I'm just too dense to figure it out. Consequently, I followed the advised on the providers page and ran aspnet_regsql and created the DB in the wizard. I can see it in the SSMS Express, but the test link in WSAT keeps failing.
I now have keyboard marks in my forehead from all the pounding.
Thanks gang.