How do I create my database?

Back

The first step to working with SQL Express is to have a tool that is designed to do just that. You can get the SQL Management Studio Express tool for free from here:

http://msdn.microsoft.com/vstudio/express/sql/download/

Make sure that you select an installation with the Management Express tool.

When SP1 and the tools are installed, open up SQL Management Studio and connect to your local Express Server. This will most likely be "localhost\SQLEXPRESS". Use Windows Authentication.

To add a database, just right click on Databases and select "New Database". Name it something like "CSK2".

 

You need to let the ASP worker process, which is the identity that ASP runs under, have "owner" permissions of these databases. To do this, drop open the new database and go to the security folder. Right-click and select "New/User". A dialog will pop up asking you for a name and rights assignments.

Your ASP worker process should be named one of two things - on most Windows XP machines this process is named "[MACHINENAME]\ASPNET". On servers and other XP machines, this process is called "[MACHINENAME]\NETWORK SERVICE". Select one of these names, and enter that name in both the Username and Login Box:

 

Finally, add this new user to the role of db_owner. This will allow for the creation of tables and SPs, and the execution of those SPs.