Installing with 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 install the IBM® UrbanCode™ Build server, install a SQL Server database. If you are evaluating IBM UrbanCode Build, you can install the database on the same computer as the IBM UrbanCode Build server.

When you install IBM UrbanCode Build, you must have the SQL Server connection information, and a user account with table creation privileges. For example, the command to install the Microsoft SQL server is similar to this code:

CREATE DATABASE ibm_ucb;

USE ibm_ucb;

CREATE LOGIN ibm_ucb WITH PASSWORD = 'password';

CREATE USER ibm_ucb FOR LOGIN ibm_ucb WITH DEFAULT_SCHEMA = ibm_ucb;

CREATE SCHEMA ibm_ucb AUTHORIZATION ibm_ucb;

GRANT ALL TO ibm_ucb;

Note: If you use the COLLATE clause, you must specify a collation that is case sensitive.

Obtain the SQL Server JDBC driver from the Microsoft™ site.
The JDBC JAR file is not included with the installation files.
Copy the JDBC JAR file to installer_directory\lib\ext directory.
Begin to install the server. See Installing the server in interactive mode. When you are prompted for the database type, enter sqlserver.
Provide the JDBC driver class that IBM UrbanCode Build 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, the string is similar to the following code:
```
jdbc:sqlserver://DB_URL:DB_PORT;databaseName=DB_NAME
```
This example shows a connection string:
```
jdbc:sqlserver://localhost:1433;databaseName=ibm_ucb
```
Finish by entering the database user name and password.