Creating databases for asset lifecycles in Microsoft SQL Server

These are the instructions for manually creating databases for lifecycle management for IBM® Rational® Asset Manager in Microsoft® SQL Server. These databases are used by the included version of IBM Rational Team Concert™.

If you are using an existing Rational Team Concert server, you can skip this task because Rational Team Concert already have the databases.

SQL Server must already be installed and running.

Use SQL Server Authentication available as part of Mixed mode (Windows Authentication and SQL Server Authentication).

Note: Windows Authentication (or Windows Integrated Security) is not supported by Rational Asset Manager or Rational Team Concert setup. For more information, see RTC APAR PI18955: [WI 233472] DOCUMENT THAT "INTEGRATED AUTHENTICATION" IS NOT SUPPORTED and The Support Authority: Resolving connection errors between WebSphere Application Server and SQL Server.

To set up SQL Server databases by using the command tool sqlcmd:

Start the command line tool. At a command prompt type sqlcmd -U login_id -P password.
Create a Jazz™ Team Server (JTS) database. From the command line tool, type:
```
CREATE DATABASE jtsdb 
GO
```
Change the ownership of the JTS database to the same user that you use for the Rational Asset Manager asset management database. The following example command assigns the user name ramDBuser as the owner of database jtsdb. From the command line tool, type:
```
USE jtsdb;
exec sp_changedbowner 'ramDBuser'
GO
```
Change the row version system for the database. From the command line tool, run this command. For CCM database, replace jts with ccm:
Note: Ensure that the connection to the database is open before running this command.
```
ALTER DATABASE jts SET READ_COMMITTED_SNAPSHOT ON 
GO
```
Change the collation of the JTS database. From the command line tool, type:
```
ALTER DATABASE jtsdb COLLATE SQL_Latin1_General_CP437_CS_AS
```
Repeat the above steps to create a Change and Configuration Management (CCM) database named ccmdb.

If you are using WebSphere® Application Server:

If you have not deployed the server setup application, deploy it to your server or cluster. To do so, see deploying to a server or deploying to a cluster.

Restriction: To create and use a cluster of application servers, you must have IBM WebSphere Application Server Network Deployment (ND).

If you are installing to a WebSphere Application Server cluster and you need to install Rational Team Concert™, you will also have to create a single application server instance for Rational Team Concert.

Then, use the server setup application to configure WebSphere Application Server to connect to your databases. If you have deployed the server setup application to your server or cluster, see Deploying and configuring application files by using the server setup application.

If you are using Apache Tomcat:

Configure Apache Tomcat and deploy the Rational Asset Manager application files. See Deploying the Rational Asset Manager server applications on Tomcat 6 or 7.