Research & Development for 3D & the Web

1. Create the new Database in SQL Server.
2. Create a new Login in SQL Server for the Database (I like to keep mine the same name as the Database name so I know what goes with what) Do this under Security > Logins
3. Create a new Database User (again, I use the same name – not necessary but good if you’re going to have a heap of DB’s and users/logins.
4. Right Click on Database and run the following ‘user update’ query:

EXEC sp_change_users_login ‘Update_One’, ‘<database_name>’ , ‘<user_login>’

(I think that’s what they are for – using the same names also eliminates the need to figure that out haha)

5. Grab the Orchard source code for the latest version from the Orchard site here:

You can also follow the installation instructions they have on their site to install Orchard from there.