Creating a database for assets in Microsoft SQL Server

These are the instructions for manually creating tables for IBM® Rational® Asset Manager in Microsoft™ SQL Server.

Before you begin

Draft comment:
mssql_instructions.dita IS THE SERVER SETUP TOPIC CONTAINED IN THE INSTALLATION FILES. The title, short description, and steps here are conrefed into that topic.

Ensure that the supported SQL Server is installed and running.
For all the versions of the SQL Server installed on the IBM Rational Asset Manager application server, install Microsoft™ JDBC Driver 4.0, which is available for download on the Microsoft site. The JDBC .jar file to use is sqljdbc4.jar.
Make sure that you know the location of the SQL scripts. Typically, the location is: path_to_installation_media\db_scripts\SQLServer.
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 IBM 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.

Procedure

To create the database tables:

Ensure that your ID has permission to execute CREATE SCHEMA statements. Typically, the database owner has this permission.
Create a new database with database name RAMDB.
The default collation option for SQL Server is case-insensitive; the IBM Rational Asset Manager database must use a case-sensitive collation to work correctly. You must select a collation sequence that ends with_BIN2 (for example, Latin1_General_BIN2). To learn more about collation options, see Windows Collation Name on the Microsoft website.
You can create databases using the command line tool. To start the command line tool, type sqlcmd -U login_id -P passwordin the command prompt.
From the command line tool, type:
```
CREATE DATABASE RAMDB COLLATE collation
GO
```
where, collation is where you specify a collation sequence. For example:
```
CREATE DATABASE RAMDB COLLATE Latin1_General_BIN2
GO 
```
Use the server setup application to populate the database.
Or
If you are not using the server setup application, run the scripts to populate the database. Perform the following to run the scripts in the command prompt:
1. Open the command prompt.
2. Type sqlcmd -d RAMDB -i path to SQLscripts\RAMSCHEMA_SQLServer.sql, and press [ENTER]. Where, RAMDB is the name of the database that you have newly created.
3. Type sqlcmd -d RAMDB -i path to SQLscripts\bootStrap_SQLServer.sql, and press [ENTER]. Where, RAMDB is the name of the database that you have newly created.
To learn more about the server setup application, see Installing Rational Asset Manager server by using Installation Manager
Verify that the tables were created.

What to do next

If you do not already have an existing Rational Team Concert server create the database for lifecycle management. To do so, see Creating databases for asset lifecycles in Microsoft SQL Server.
If you already have Rational Team Concert:

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 IBM Rational Asset Manager application files. See Deploying the IBM Rational Asset Manager server applications on Tomcat 6 or 7.