Creating a new database user and schema

Add a new user to connect to the newly created database.

Procedure

  1. On the database server, open the SQL Server Management Studio.
  2. In the left pane under the server name open Security.
  3. Right-click on Logins then select New Login…
    A Login - New window displays.
  4. In the Login name field, enter an user name (e.g. isource).
  5. SQL Server Authentication should be selected. Enter a Password (e.g. isource) and Confirm password for SQL Server Authentication.
  6. Depending on your local password policy, you can enforce password policy and password expiration.
  7. Use the drop down list to select the Default database; select your newly created database.
    No other changes are required for the General information.
  8. Click Server Roles in the left pane.
  9. Select (check the boxes next to) public and sysadmin in the right pane.

    This allows the Content Manager DBUpgradeTool (DBUT) to fully execute all necessary tasks to update your database with new releases.

  10. Click User Mapping in the left pane.
  11. Select (check the boxes next to) the newly created database in the upper right pane.
  12. In the upper right pane, in the Default Schema field for your database, enter dbo.
  13. In the bottom pane, select (check the boxes next to) db_owner and public.
  14. In the Login - New window, click Status in the left pane.
  15. Verify that Grant is selected for Permission to connect to the database engine and that Enabled is selected for Login.
  16. Click OK.
  17. Click File > Exit.