Adding the User or Group
- Connect to the database with the SQL Server Management Studio.
- Open the Security branch, right-click on Logins and select New Login.
- Choose Windows Authentication for the login, and click Search.
- Click Object Types…, select Groups and Users, and click OK.
- Click Locations..., choose the location wherein your user or group is residing, and click OK.
- Enter the name of the group or user, click Check Names, select the name of your user or group, and click OK.
If you selected a group, all users in this group will be able to access the databases where this group is defined as the database owner. Also, if you selected a group, you should add at least one user which will become the main database owner.
Setting up the Database
The database that will be used by the UMS either needs to have a domain user as the database owner or grant a domain user or group the necessary access rights.
Setting the Domain User as Owner
- Open the Create database dialog.
- Set a Database name.
- For the Owner of the database, click ... on the right side to browse for a user.
- Select the user that will be the database owner.
Check and Grant Access Rights to the Domain User or a Domain Group
- Go to the Security branch of the database server.
- Select the user or group that is to be used for database login and open Properties.
The dialog Login Properties - [Location] opens.
- Click User mapping to map your UMS database to the user or group.
- In the Users mapped to this login area, select your database.
For the database owner defined before, all settings (User: "dbo" and Default Schema: "dbo") are valid.
For a group, your group name is appropriate. The Default Schema must be set to "dbo".
- In the area Database role membership for: [your UMS database], activate db_owner.
- Click OK to confirm the changes.
The database that will be used by the UMS Server is created.
A user or group with access to this database is defined.