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 Read more [...]