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
- Ensure that SQL Server 2005, 2008 or 2008R2 is installed and running.
- Install one of the following drivers on the
SQL Server that runs Rational Asset Manager.
For both drivers, the JDBC .jar file is sqljdbc4.jar.
- Microsoft JDBC Driver 3.0 for SQL Server that can be downloaded from http://www.microsoft.com/en-us/download/details.aspx?id=19847.
- Microsoft JDBC Driver 4.0 for SQL Server that can be downloaded from http://www.microsoft.com/en-us/download/details.aspx?id=11774.
- 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 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:
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), which is not bundled with IBM Rational Asset Manager.
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.