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.
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
- Obtain the SQL Server JDBC driver from the Microsoft site. The JDBC JAR
file is not included among the installation files.
- Copy the JDBC JAR file to installer_directory\lib\ext.
- Begin server installation, see Installing the server.
When you are prompted for the database type, enter sqlserver.
- Provide the JDBC driver class IBM UrbanCode Deploy uses
to connect to the database. The default value is com.microsoft.sqlserver.jdbc.SQLServerDriver.
- 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
- Finish by entering the database user name and password.