(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'
Comments
Log in or register to comment.