You can use Microsoft SQL
Server as a supporting database with IBM® UrbanCode Release
server. Create the database before you install IBM UrbanCode Release.
Typically the database is installed on a computer other than the one
where the server is located.
About this task
When you install
IBM UrbanCode Release,
you need the database connection information and the JDBC JAR file.
The user account for the database must have table creation privileges.
Procedure
- Create a Microsoft SQL
Server database named ibm_ucr. The following
commands are an example of how you might create this database:
CREATE DATABASE ibm_ucr
;
USE ibm_ucr
;
CREATE LOGIN ibm_ucr
WITH PASSWORD = 'password';
CREATE USER ibm_ucr
FOR LOGIN ibm_ucr
WITH DEFAULT_SCHEMA = ibm_ucr
;
CREATE SCHEMA ibm_ucr
AUTHORIZATION ibm_ucr
;
GRANT ALL TO ibm_ucr
;
- Obtain the SQL Server JDBC driver JAR file from the Microsoft site. The JDBC JAR
file is not included with the installation files. This file must be
available when you run IBM Installation Manager.
- Record the values of the database parameters so that you
can supply them when you run IBM Installation Manager and
install IBM UrbanCode Release.
The following parameters are typical for an installation of Microsoft SQL Server used to
support IBM UrbanCode Release:
| Parameter |
Value |
|---|
| Database user name |
ibm_ucr |
| Database password |
user_account_password |
| Database driver class |
com.microsoft.sqlserver.jdbc.SQLServerDriver |
| Database connection string |
jdbc:sqlserver://database_server:1433;databaseName=ibm_ucr |