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 - Cloud Database

To pre-create a Microsoft SQL Server database on Microsoft Windows for the BMC Remedy AR System – Cloud Database product, use the following lines of code:


use tempdb  

CREATE DATABASE "CARSystem" ON (NAME = "CARSystem_data", FILENAME =  'c:\CARSys.mdf', SIZE = 2000MB)
LOG ON (NAME = "CARSystemp_log",  FILENAME = 'c:\CARSysLog.ldf', SIZE = 1000MB)  

CREATE LOGIN "CARAdmin" WITH PASSWORD = 'AR#Admin#', DEFAULT_DATABASE = CARSystem  

use CARSystem  

CREATE USER "CARAdmin" FOR LOGIN "CARAdmin"  

use CARSystem  
exec sp_addrolemember 'db_owner', 'CARAdmin'

 

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

BMC Cloud Lifecycle Management 3.1