35.3 Configuring a SQL Server Database

This section provides configuration options for using an SQL Server database for the User Application. For information about supported versions of SQL Server, see System Requirements for the Identity Applications.

35.3.1 Configuring the Character Set

SQL Server does not allow you to specify the character set for databases. The User Application stores SQL Server character data in a NCHAR column type, which supports UTF-8.

35.3.2 Configuring the Admin User Account

After installing Microsoft SQL Server 2014, create a database and database user using an application such as SQL Server Management Studio. The database user account must have the following privileges:

  • CREATE TABLE

  • DELETE

  • INSERT

  • SELECT

  • UPDATE

NOTE:It is recommended to use JDBC JAR version sqljdbc4.jar.