×
 
 
  •  
$helper.renderConfluenceMacro('{bmc-global-announcement:$space.key}')

Unsupported content

 

This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.
BMC Cloud Lifecycle Management 4.5 ... Installing Preparing for installation Setting up the installation environment

(Optional) 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.

Last modified by Lisa Greene on Jul 27, 2016

Comments

Log in or register to comment.

(Optional) Setting up BMC Network Automation on Linux
(Optional) Pre-creating an Oracle database for BMC AR System Server - Cloud Portal and Database
© Copyright 2024 BMC Software, Inc.
Legal notices

Powered by Atlassian Confluence and Scroll Viewport

© Copyright 2005-2024 BMC Software, Inc. Use of this site signifies your acceptance of BMC’s Terms of Use . BMC, the BMC logo, and other BMC marks are assets of BMC Software, Inc. These trademarks are registered and may be registered in the U.S. and in other countries.