Configuring a Microsoft SQL Server database for the IBM UrbanCode Deploy server
To use an SQL Server database with the server, before you install the server, install the SQL Server database and provide the driver file for the server installation process.
Before you install the IBM® UrbanCode® Deploy server, install an SQL Server database. Specify case-sensitive collation for the database. If you are evaluating IBM UrbanCode Deploy, you can install the database on the same system as the IBM UrbanCode Deploy server.
When you install IBM UrbanCode Deploy, you need the SQL Server connection information, and a user account with table-creation
privileges.
Note: The user account cannot have the sysadmin
role.
For example, the commands to create a database, create an SQL server user, and configure the database, might look like the following example:
CREATE DATABASE ucd;
USE ucd;
CREATE LOGIN ucd WITH PASSWORD = 'password';
CREATE USER ucd FOR LOGIN ucd WITH DEFAULT_SCHEMA = ucd;
CREATE SCHEMA ucd AUTHORIZATION ucd;
GRANT ALL TO ucd;
Note: It is recommended that you change the database to a case-sensitive
collation.
- The SQL Server should
have:
READ_COMMITTED_SNAPSHOT ON
- The SQL Server compatibility should be set to 110.
- Enable the Always ON availability group feature to use high-availability for recovery or failover. Refer to the SQL Docs for a detailed procedure.
Configuring a Microsoft SQL Server database for the IBM UrbanCode Deploy server as follows: