How do I get asp.net to support authentication on a new development site?

I tried creating a new website because the current one did not work but it cannot create the membership database.

I have SQL 2005 installed on the machine but just want the basic, vanilla login to work because the production server has it's own SQL server but I need to test roles and stuff on the development server.

Thanks