Installing Microsoft SQL Server

Before installing the Serena Release Automation server, install a SQL Server database. If you are evaluating Serena Release Automation, you can install the database on the same machine where the Serena Release Automation server will be installed.

When you install Serena Release Automation, you will need the SQL Server connection information, and a user account with table creation privileges.

To install the MS SQL Server database:

Download and install the JDK–not a JRE–that corresponds to your operating system (see http://www.oracle.com/technetwork/java/javase/downloads/).
Download the SQL Server JDBC driver from http://www.microsoft.com/en-gb/download/ and save it in your Apache-Tomcat libs folder.
Install the JDBC driver.
Using the SQL Server Management Studio, execute the following commands:
CREATE DATABASE serena_ra;

USE serena_ra;

CREATE LOGIN serena_ra WITH PASSWORD = 'password';

CREATE USER serena_ra FOR LOGIN serena_ra WITH DEFAULT_SCHEMA = serena_ra;

CREATE SCHEMA serena_ra AUTHORIZATION serena_ra;

GRANT ALL TO serena_ra;
Begin server installation, see Server Installation.
Select the SQL Server database option in the installer.
Provide your SQL Server database details:

Table 1. MS SQL Server Database Installation Details table

Field	Description
JDBC driver jar filename	Browse to and select the JDBC driver jar file you downloaded in step 2.
JDBC driver class	The default value is: `com.microsoft.sqlserver.jdbc.SQLServerDriver`
Database connection string	The format depends on the JDBC driver. Typically, it is similar to: `jdbc:sqlserver://[DB_URL]:[DB_PORT];databaseName=[DB_NAME]` For example, `jdbc:sqlserver://localhost:1433;databaseName=serena_ra`
User	Database username. The default is `serena_ra`.
Password and Confirm password	Database username password, and re-entry for confirmation.