|
Add a SQL Server Login and User
|
Previous Top Next |
| 1. | Expand the Security folder under the Databases folder.
|
| 2. | Right click on the Logins folder and select New Login.
|
| 3. | On the General page, type the Login name.
|
| 4. | Select the SQL Server authentication radio button and type the Password twice. If you wish to use Windows authentication, select the Windows authentication radio button and no password information is required because the password properties for the Windows account are used; skip to Step 6.
|
| 5. | Check the Enforce password policy and uncheck the Enforce password expiration and User must change at next login check boxes.
|
| 6. | Click OK
|
| 7. | Expand the Security folder under the RMS database folder.
|
| 8. | Right click on the Users folder and select New User.
|
| 9. | On the General page, type the User name and then type the Login name that you wish to associate with the user account.
|
| 10. | At the Database role membership list box, check db_owner.
|
| 11. | Click OK.
|