Installation Planning › Installation Prerequisites › Database Considerations

Database Considerations

Install and configure the database with the following parameters:

• For database version support, see the Release Notes.
• The database can be local to the SA Manager installation or on a remote server. As a best practice, install the database on the SA Manager system in smaller scale installations (less than 60,000 CIs). Install on a remote system in mid-scale to large-scale installations.
• Configure the database to use Mixed Mode authentication with the "sa" user name and password. You can then enter a SQL Server user name and password during CA SOI installation.
• As a best practice, the database administrator should create the SAMStore database before you install the product and create a user with db_owner privileges for the database. In this situation, the CA SOI installer requires only the user name defined for the database. Otherwise, the installer requires you to enter a database user with sysadmin privileges to create a new database.
• Select the default instance or specify a named instance during the database installation. During CA SOI installation, specify a database instance and port with the option of using the default instance. The database connection behaves as follows with regards to the instance and port values:
  • If you change the port but not the default instance, the database tries to connect to that port using the instance name to find the port. For this lookup to work, the SQL Browser service must be running on the SQL Server node.
  • If you change the instance name but not the default port, the driver tries to resolve the instance name to the port supplied by the SQL Browser Service. If the resolution is successful, the database connects to that port.
  • If you change both default values, the database connects using only the port and the instance is ignored.
  • If you use a named instance and the SQL Browser service is not running or the database server is on a different network than the BusinessObjects server, BusinessObjects may have trouble connecting to the database when installing the CA SOI reports. To help ensure a successful connection in this situation, select Administrative Tools, Data Sources (ODBC) on the database server and add the instance name to the SAMStore DSN (for example, dbserver\myinstance).
• For collation settings during database installation, select SQL collations (used for compatibility with previous versions of SQL Server) and highlight Dictionary order, for use with 1252 Character Set.
• The database must be case-insensitive.
• The default name of the SA Store database is SAMStore, but you can change the database name if necessary.
• For more information about database disk space requirements, see the Release Notes and the Database Sizing section in the Administration Guide.