Walkthrough: Setting up a SQL Server database
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:
Introduction
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.
What does this walkthrough show?
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.
What do I need to do before I get started?
For this walkthrough, you must have SQL Server installed and you must have credentials to access SQL Server.
How to set up a SQL Server database and user account
Step | Example screen | |
---|---|---|
1 | Start the Microsoft SQL Server Management Studio application and connect to the Microsoft SQL database server. |
|
2 | Expand the database server. Right-click the Databases folder and select New Database. | |
3 | Provide a name for the database you are setting up and click OK to exit the New Database wizard. | |
4 | Create the login credentials for the database. Right-click the Security folder and select New > Login. | |
5 | Create log in credentials for the database.
|
|
6 | Assign roles to the login name.
| |
7 |
| |
8 | To reduce the likelihood of database deadlocks, execute the following steps:
|
Wrapping it up
Congratulations. You have successfully set up a database and user in SQL Server. You are now ready to run the unified product installer.
Where to go from here
Walkthrough: Installing on Windows using the unified installer
Comments