Installing the aspnetdb on SqlExpress

I've been cruising around the ASP.NET 2.0 beta forums and the web w/ Google at my side, but this one is just kicking my butt so far.

I've got VS.NET 2005 Beta 2 and SQL Express installed on a Virtual PC running WinXP SP2 and I'm trying to run the aspnet_regsql -W (the wizard) to create the aspnetdb so that I can play with WebParts and drop a WebPartManager on one of my ASP.NET pages. When I provide the wizard with all of the information and click "Next >>" to have it create the database I get an error - "Creation or change of the SQL Server database failed"

I've seen lots of posts and messages around the web that say, "just run the wizard and it will setup the database for you" but...that's not happening for me. Anybody know if there are web.config entries or other prerequisites to check on before running the wizard? Anybody else had this problem?

3 Comments

  • If you have SQL Express installed, then you don't need to-do anything in order to provision the database. Just use webparts (or membership or roles, etc), and the first time it is used ASP.NET will create a sql express database for you under your app_data directory that has all of the schema installed and configured.



    Hope this helps,



    Scott

  • Hi Scott - I've read about that also - but I'm getting an error message when I run my ASP.NET 2.0 pages about how it couldn't create the database. I'll try and get the exact error message....

  • The error message should detail steps to fix it if you are running into it. Often these are a result of ACL problems.



    Feel free to email me a copy of the error if you can't get through it, and I'd be happy to help walk you though how to fix it.



    Thanks,



    Scott

Comments have been disabled for this content.