Skip to Content
Information
Unsupported content 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.

Pre-creating a SQL Server database for BMC Remedy AR System and BMC Remedy ITSM Suite

To pre-create a Microsoft SQL Server database on Microsoft Windows for the BMC Remedy AR System and BMC Remedy IT Service Management Suite product, use the following lines of code:

Warning

Note

You must name the database as "ARSystem". Otherwise, your product installation might fail.


use tempdb

CREATE DATABASE "ARSystem" ON (NAME = "ARSystem_data", FILENAME = 'c:\ARSys.mdf', SIZE = 7000MB) LOG ON (NAME = "ARSystemp_log", FILENAME = 'c:\ARSysLog.ldf', SIZE = 1000MB)

CREATE LOGIN "ARAdmin" WITH PASSWORD = 'AR#Admin#', DEFAULT_DATABASE = ARSystem

use ARSystem

CREATE USER "ARAdmin" FOR LOGIN "ARAdmin"

use ARSystem

exec sp_addrolemember 'db_owner', 'ARAdmin'

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Cloud Lifecycle Management 3.1