This documentation applies to the 8.1 version of Remedy IT Service Management Suite, which is in "End of Version Support." You will not be able to leave comments.

To view the latest version, select the version from the Product version menu.

Preparing your Microsoft SQL Server database before you upgrade

This section describes the steps you should perform with your Microsoft SQL Server database when you install BMC Remedy AR System or any application in the BMC Remedy IT Service Management Suite.

Tips to remember

  • Purge the transaction log frequently to prevent it from filling up during installation.
  • Back up the SQL Server log files, and then change the SQL Server Transaction Logging mode from FULL to SIMPLE.
  • If the database is not configured to extend automatically, make sure that you have set the following:
    • Set the BMC Remedy AR System data file size to 1 GB or greater; BMC Software recommends at least 2 GB. If you are planning to install CMDB or ITSM applications in addition to BMC Remedy AR System, add 2048 MB to the data file for each additional application.
    • Set the log file size to 1 GB or greater. If you plan to install CMDB or ITSM applications in addition to BMC Remedy AR System, add 2048 MB to the data file for each additional application.

      Note

      BMC recommends that you set the value of the Next-ID-Block-Size: Server option in the ar.cfg or ar.conf file to 100.

To prepare your Microsoft SQL Server database

  1. Install the Microsoft SQL Server database.
    You can install the SQL Server database on the same computer where BMC Remedy AR System is installed, or on a remote server that is networked to the computer where you plan to install BMC Remedy AR System.
  2. Install SQL Server clients (that is, the drivers).
    For remote installations, install the SQL Server clients on the same computer as the BMC Remedy AR System server.
  3. Create an instance of the database.
  4. Set your SQL Server connections to allow TCP/IP:
    1. Open the SQL Server Configuration Manager.
    2. Click Network Configuration for your SQL Server instance.
    3. Make sure that TCP/IP Protocol is enabled.
    4. View the TCP/IP Properties dialog box for your database instance, and make sure that the IP Addresses tab has a TCP Port number specified. (The default port is 1433.)
    5. Restart all SQL Server services to effect this change.
  5. Determine data file and log file sizes for your SQL Server database.

    Note

    During the installation, you are required to declare table sizes. This enables you to pre-size the data files to improve application performance.

  6. Make sure that your database can accept network communication with the parameters entered in the installation.
    The network communication will use ODBC and be able to recognize your ODBC data source.

To optimize Microsoft SQL Server 2005 (or later) after you finish installing or upgrading the AR System server

Important

Perform these tasks immediately after you complete the AR System server installation or upgrade and before you install any other BMC applications (for example, BMC Atrium Core).

If you are using Microsoft SQL Server 2005, make sure you have installed the most current Service Pack.

  1. Stop the AR System server to ensure that all connections to the AR System database are closed.
  2. (For a server group or a shared database) Stop all the AR System instances.
  3. Set the following SQL Server forced parameterization and SNAPSHOT isolation parameters:
    • ALTER DATABASE ARSystem SET PARAMETERIZATION FORCED
    • ALTER DATABASE ARSystem SET READ_COMMITTED_SNAPSHOT ON
      For example:
      alter database ARSystem set recovery simple;
      alter database ARSystem set single_user with Rollback immediate;
      alter database ARSystem set READ_COMMITTED_SNAPSHOT ON;
      alter database ARSystem set multi_user;
      alter database ARSystem set PARAMETERIZATION FORCED;
      
  4. Verify the values by issuing the following command:
    SELECT is_read_committed_snapshot_on FROM sys.databases where name = 'ARSystem'

Windows Authentication mode and Microsoft SQL Server

Microsoft SQL Server installation can support two authentication modes:

  • Windows authentication mode
  • Mixed authentication mode

To find the supported authentication mode in your SQL Server environment, connect to the SQL Server instance from Management Studio > Server Properties > Security.

If only Windows authentication mode is supported, choose Windows authentication when you install the BMC Remedy AR System server.

If mixed authentication mode is supported, choose Windows authentication or SQL Server authentication when you install the BMC Remedy AR System server.

To pre-create a Microsoft SQL Server database

If you do not have DBA privileges, your database administrator must create an empty database so that you are not asked for database information during the installation.

Note

Create the folder (for example, c:\data, before you pre-create the database. Otherwise, the database creation fails.

  1. In a Query Window, run the following command:
    use tempdb
  2. Create a database, for example:
    CREATE DATABASE "ARSystem" ON (NAME = "ARSystem_data", FILENAME = 'c:\data\ARSys.mdf', SIZE = 500MB) LOG ON (NAME = "ARSystempt_log", FILENAME = 'c:\data\ARSysLog.ldf', SIZE = 100MB)
    CREATE LOGIN "ARAdmin"WITH PASSWORD = 'AR#Admin#', DEFAULT_DATABASE = ARSystem
  3. Use the created database, for example:
    use ARSystem
  4. Create a user name and login, for example:
    CREATE USER "ARAdmin" FOR LOGIN "ARAdmin"
  5. Make the user the db_creator, for example:
    sp_addrolemember 'db_creator', 'ARAdmin'

Related topics

Using Microsoft SQL Server with BMC Remedy AR System from the AR System documentation

Where to go from here

Completing the planning spreadsheet for an upgrade

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments