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 AR System Server – Cloud Portal and Database

As an optional step, if you want to pre-create a Microsoft SQL Server database on Microsoft Windows for BMC AR System Server – Cloud Portal and Database, use the following lines of code:

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:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ARSys.mdf', SIZE = 7000MB) LOG ON (NAME = "ARSystemp_log", FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\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'

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