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™.
Before you begin
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.
Procedure
To set up SQL Server databases by using the command tool sqlcmd:
What to do next
- 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.