To use a Microsoft SQL database for the VMware Identity Manager, you must create a new database in the Microsoft SQL server.

About this task

You create for a database named saas on the Microsoft SQL server and create a login user named horizon.

Note:

The default collation is case-sensitve.

Prerequisites

  • Supported version of the Microsoft SQL server installed as an external database server.

  • Load balancing implementation configured.

  • Administrator rights to access and create the database components using Microsoft SQL Server Management Studio or from another Microsoft SQL Server CLI client.

Procedure

  1. Log in to the Microsoft SQL Server Management Studio session as the sysadmin or a user account with sysadmin privileges.

    The editor window appears.

  2. In the toolbar, click New Query.
  3. Cut and paste the following commands into the editor window.

    Microsoft SQL Commands

    CREATE DATABASE saas
    COLLATE Latin1_General_CS_AS;
    ALTER DATABASE saas SET READ_COMMITTED_SNAPSHOT ON;
    GO
    BEGIN
    CREATE LOGIN horizon WITH PASSWORD = N'H0rizon!';
    END
    GO
    USE saas;
    IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'horizon')
    DROP USER [horizon]
    GO
    CREATE USER horizon FOR LOGIN horizon
    WITH DEFAULT_SCHEMA = saas;
    GO
    CREATE SCHEMA saas AUTHORIZATION horizon
    GRANT ALL ON DATABASE::saas TO horizon;
    GO
  4. On the toolbar, click !Execute.

    The Microsoft SQL database server is now ready to be connected to the VMware Identity Manager database.

    The server role used to grant server-wide security privileges is set to public. The saas database role membership that should be enabled are public, db_datareader, db_datawriter, db_ddladmin, db_owner, SQLAgentUserRole, SQLAgentOperatorRole, and SQLAgentREaderRole. No other roles should be set.

What to do next

Configure the external database on the VMware Identity Manager server. Go to the VMware Identity Manager administration console Appliance Settings > VA Configuration > Database Connection Setup page. Enter the JDBC URL as jdbc:sqlserver://<hostname-or-DB_VM_IP_ADDR>;DatabaseName=saas. Enter the user name and password created for the database. See Configure VMware Identity Manager to Use an External Database