Preparing your Microsoft SQL Server database before you install the AR System server
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.
- 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.
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
- 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.
- 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.
- Create an instance of the database.
- Set your SQL Server connections to allow TCP/IP:
- Open the SQL Server Configuration Manager.
- Click Network Configuration for your SQL Server instance.
- Make sure that TCP/IP Protocol is enabled.
- 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.)
- Restart all SQL Server services to effect this change.
Determine data file and log file sizes for your SQL Server database.
During the installation, you are required to declare table sizes. This enables you to pre-size the data files to improve application performance.
- 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
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.
- Stop the AR System server to ensure that all connections to the AR System database are closed.
- (For a server group or a shared database) Stop all the AR System instances.
- 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
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;
- Verify the values by issuing the following command:
SELECT is_read_committed_snapshot_on FROM sys.databases where name = 'ARSystem'
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.
When you use the Windows authentication mode with SQL Server note the following:
- To install or upgrade the BMC Remedy AR System Server on the Windows Server, you should log on the Windows Server with the domain account used for Windows authentication mode.
- The domain account used with Windows authentication mode should be a full administrator on the Windows Server and should have db_securityadmin and setupadmin roles in SQL Server. The domain account should be DBA of the BMC Remedy AR System database.
- When the install or upgrade completes, it is possible to deny certain policies to the domain account used with Windows authentication mode for security reasons. But ensure that denying policies should not result in the loss of functionality. For any upgrades later, all the policy restrictions should be removed and the domain account should be returned to full administrator till the upgrade completes.
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.
In a Query Window, run the following command:
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
Use the created database, for example:
Create a user name and login, for example:
CREATE USER "ARAdmin" FOR LOGIN "ARAdmin"
Make the user the db_creator, for example:
sp_addrolemember 'db_creator', 'ARAdmin'