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

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.

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.

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.

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://<DB_VM_IP_ADDR>;DatabaseName=saas. Enter the user name and password created for the database. See Add an External Database to the VMware Identity Manager Appliance