This topic walks you through the process of using Microsoft SQL Server to set up a database that will be used when installing BMC BladeLogic Server Automation (BSA) on Microsoft Windows.
Warning
These tasks should be performed by a database administrator (DBA). Perform the steps in the exact order in which they are described.
This topic includes the following sections:
This topic is intended for system and database administrators preparing to install BSA. The goal of this topic is to demonstrate how to use SQL Server to set up a database and login ID for that database. Access to a database is a prerequisite to running the BSA unified product installer or when manually installing BSA.
In this walk through, we set up a database and a user login that can access the database.
When installing BSA using the unified product installer, the installation program automatically populates a database schema. The installer accesses that database using connection information that is defined in this walkthrough.
If you are installing BSA and its database manually (rather than by using the unified product installer), you can use this procedure to set up a database and then later run the script that populates the database schema for BSA.
For this walkthrough, you must have SQL Server installed and you must have credentials to access SQL Server.
Start the Microsoft SQL Server Management Studio application and connect to the Microsoft SQL database server. Note: You can connect a Windows default Application Server node only to a Microsoft SQL Server database. Provide a name for the database you are setting up and click OK to exit the New Database wizard. Create the login credentials for the database. Right-click the Security folder and select New > Login. Assign roles to the login name. Step Example screen 1 2 Expand the database server. Right-click the Databases folder and select New Database. 3 4 5 Create log in credentials for the database.
Note: Do not specify a BMC Server Automation database password for the account that begins with an equal sign (=).6 7 8 To reduce the likelihood of database deadlocks, execute the following steps: ALTER DATABASE <db_name> SET ALLOW_SNAPSHOT_ISOLATION ON;
<db_name>
is the name of the database you set up earlier in this procedure.ALTER DATABASE <db_name> SET READ_COMMITTED_SNAPSHOT ON;
is the name of the database you set up earlier in this procedure.<db_name>
Congratulations. You have successfully set up a database and user in SQL Server. You are now ready to run the unified product installer.