Creating a new database user and schema
Add a new user to connect to the newly created database.
Procedure
- On the database server, open the SQL Server Management Studio.
- In the left pane under the server name open Security.
- Right-click on Logins then select New Login…
A Login - New window displays.
- In the Login name field, enter an user name (e.g. isource).
- SQL Server Authentication should be selected. Enter a Password (e.g. isource) and Confirm password for SQL Server Authentication.
Note: SDL is not able to assist you if you do not know the password so it is advised to store the password in a secure place.
- Depending on your local password policy, you can enforce password policy and password expiration.
Note: Keep in mind to change the connect string whenever you change the password of the database user!
- Use the drop down list to select the Default database; select your newly created database.
No other changes are required for the General information.
- Click Server Roles in the left pane.
- 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.
Note: If you want to reduce the server roles for everyday work, read Optionally minimize the database user's roles and permissions. - Click User Mapping in the left pane.
- Select (check the boxes next to) the newly created database in the upper right pane.
- In the upper right pane, in the Default Schema field for your database, enter dbo.
- In the bottom pane, select (check the boxes next to) db_owner and public.
Note: If you want to reduce the permissions for day to day usage, read Optionally minimize the database user's roles and permissions.
- In the Login - New window, click Status in the left pane.
- Verify that Grant is selected for Permission to connect to the database engine and that Enabled is selected for Login.
- Click OK.
- Click File > Exit.