Documentation Center

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 isource.
  5. SQL Server Authentication should be selected. Enter a Password and Confirm password for SQL Server Authentication.
    By default the password is isource, however the password may be one of your choice.
  6. Depending on your local password policy, you can enforce password policy and password expiration. When both are enabled, keep in mind to change the connect string of isource at password expiration time.
  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 SDL LiveContent Architect DatabaseUpgradeTool (DBUT) to fully execute all necessary tasks to update your database with new releases. This is strongly advised.
  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.