Configuring a Microsoft SQL Server database
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.
The IBM UrbanCode Release database consists of approximately fifty tables. While storage requirements vary by installation, database storage of 10-20 GB is sufficient for most installations. The Microsoft SQL Server documentation provides several utilities that you can use to determine storage usage. Many users see a performance boost when the data files and log files are located on separate drives.
To configure the Microsoft SQL Server database complete the following 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 the install program.
Record the values of the database parameters so that you can supply them during the
installation of IBM UrbanCode
Release. The following parameters are typical for an installation of Microsoft SQL Server used to support IBM UrbanCode
Parameter Value Database user name ibm_ucrNote: This account must have table creation privileges and database owner (DBO) privileges. You can remove the DBO privileges after the server runs for the first time. Database password user_account_password Database driver class com.microsoft.sqlserver.jdbc.SQLServerDriver Database connection string
jdbc:sqlserver://database_server:1433;databaseName=ibm_ucrIf your database server uses integrated security, include the integratedSecurity parameter, as in the following example:
- Shutdown the IBM UrbanCode Release server.
- Drop the database schema.
- Assign DBO permissions to the database user account.
- Restart the server. IBM UrbanCode Release recreates the schema. You can remove DBO privileges from the database user account after the server restarts for the first time.