Add the db_owner Role Before Upgrade

If you revoked the db_owner role on the Microsoft SQL database, you must add it back before performing an upgrade to the latest version of VMware Identity Manager.

Prerequisites

Review the Installing and Configuring VMware Identity Manager (Windows), prerequisites information about creating the database.

Add the db_owner role to the same user that was used during installation:

Procedure

1. Log in to the Microsoft SQL Server Management Studio as a user with sysadmin privileges.
2. Connect to the database instance for VMware Identity Manager.
3. Enter the following commands.

   If you are using Windows Authentication mode, use the following commands:

   USE <saasdb>;
   ALTER ROLE db_owner ADD MEMBER <domain\username>; GO 
   						  

   Make sure that you replace <saasdb> with your database name and <domain\username> with the relevant domain and user name.

   If you are using SQL Server Authentication mode, use the following commands:

   USE <saasdb>;
   ALTER ROLE db_owner ADD MEMBER <loginusername>; GO 
   						  

   Make sure that you replace <saasdb> with your database name and <loginusername> with the relevant user name.