Installing Microsoft SQL Server

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

When you install Deployment 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 the SQL Server JDBC driver from http://www.microsoft.com and save it in your application server libs directory for Tomcat or lib directory for JBoss.
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;

Note: The GRANT ALL option does not grant all possible permissions. Granting ALL grants a subset of privileges that vary for each securable. For more information, see http://technet.microsoft.com/en-us/sqlserver/default.
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://serverName:1433;databaseName=serena_ra`
User	Database username. The default is `serena_ra`
Password and Confirm password	Database username password, and re-entry for confirmation.