Configuring a Microsoft SQL Server database

Before you install the server, install the SQL Server database and provide the JDBC JAR file for the installation process.

Before you begin

Before you install the IBM® UrbanCode Deploy server, install a SQL Server 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 can not have the sysadmin role.

Before you install the IBM UrbanCode Deploy server, install an SQL Server database. If you are evaluating IBM UrbanCode Deploy, you can install the database on the same system as the IBM UrbanCode Deploy server:

CREATE DATABASE ibm_ucd;

USE ibm_ucd;

CREATE LOGIN ibm_ucd WITH PASSWORD = 'password';

CREATE USER ibm_ucd FOR LOGIN ibm_ucd WITH DEFAULT_SCHEMA = ibm_ucd;

CREATE SCHEMA ibm_ucd AUTHORIZATION ibm_ucd;

GRANT ALL TO ibm_ucd;

Procedure

  1. Obtain the SQL Server JDBC driver from the Microsoft site. The JDBC JAR file is not included among the installation files.
  2. Copy the JDBC JAR file to installer_directory\lib\ext.
  3. Begin server installation, see Installing the server. When you are prompted for the database type, enter sqlserver.
  4. Provide the JDBC driver class IBM UrbanCode Deploy uses to connect to the database. The default value is com.microsoft.sqlserver.jdbc.SQLServerDriver.
  5. Next, provide the JDBC connection string. The format depends on the JDBC driver. Typically, it is similar to the following code:
    jdbc:sqlserver://DB_URL:DB_PORT;databaseName=DB_NAME
    For example:
    jdbc:sqlserver://localhost:1433;databaseName=ibm_ucd
  6. Finish by entering the database user name and password.

Feedback