Connecting to a Microsoft SQL Database Server

Verify the following:

Database type and version

Verify that OpenText Application Quality Management supports your database type and version.

Note: For the most up-to-date supported environments, see the Support Matrix.
Database server name Verify the name of the database server.
Database user permissions Verify that you have the database permissions required to connect to the Microsoft SQL database server (not applicable for Windows Authentication). For a list of required permissions, see User Permissions for Connecting to a Microsoft SQL Database Server.
Site Administration database schema

To install on an existing Site Administration database schema (second node or upgrade), you must have:

  • The existing database schema name and the database administrator permissions required to connect to the database server.

  • Full read/write permissions on the existing repository.

  • OpenText Application Quality Management must have access to the previous Site Administration schema repository path.

  • Full read/write permissions for the OpenText Application Quality Management user to the previous schema repository path.

  • The Confidential Data Passphrase that was used to create the existing schema.

For schema name and password considerations, see Site Administration Database Schema Considerations: SQL.
Text Search Verify that the text search component is installed on the server, even if you do not intend to use it.