Configuring Microsoft SQL Server

Before you install the IBM® UrbanCode Release server, create an SQL Server database. Ideally the database is installed on a computer other than the one where the server is located.

When you install IBM UrbanCode Release , you need the connection information, and a user account with table creation privileges.

To install the database, take the following steps:

  1. Install the database with the following parameters:

    CREATE DATABASE uRelease
    ;
    
    USE uRelease
    ;
    CREATE LOGIN uRelease
     WITH PASSWORD = 'password';
    CREATE USER uRelease
     FOR LOGIN uRelease
     WITH DEFAULT_SCHEMA = uRelease
    ;
    CREATE SCHEMA uRelease
     AUTHORIZATION uRelease
    ;
    GRANT ALL TO uRelease
    ;
  2. 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 tomcat_directory\lib.

  3. Modify the following parameters in the server.properties file:

    	database.type=sqlserver
    	hibernate.connection.driver_class=
    		com.microsoft.sqlserver.jdbc.SQLServerDriver
    	hibernate.connection.username=urelease
    	hibernate.connection.password=urelease
    	hibernate.connection.url=
    		jdbc:sqlserver://[DB_URL]:[DB_PORT];databaseName=[DB_NAME]
    Note:

    Database configuration is done by modifying parameters in the server.properties file that is in user_home_directory/.urbancode/urelease/conf. On UNIX, the user_home_directory is /home; on Windows it is determined by the user profile, which typically is \Users\current_user. Because IBM UrbanCode Release is deployed as a Tomcat web application, the conf file will not be created until IBM UrbanCode Release is deployed, which means that the configuration changes cannot be made until after initial deployment.

    A typical hibernate.connection.url might be:

    jdbc:sqlserver://localhost:1433;databaseName=uRelease

    Note:

    Initially, the password contains an encrypted string. Overwrite the string with the new password. The first time the password is entered it will be plain text, but will be encrypted the next time IBM UrbanCode Release starts.

  4. When you are finished, restart the Tomcat server.


Feedback