Creating SQL Server databases and setting up the database server
For information about the databases supported for use with BMC Decision Support – Network Automation, see System requirements.
While setting up the databases described in these instructions, record the database parameter values in the ETL Database Configuration row of the Installation worksheet. You are prompted for the database parameter values during the BMC Decision Support – Network Automation installation.
To create the SQL Server databases
- On the database server, create the following databases:
- BCAN_ETL_WORK for the ETL work repository
- BCAN_ETL_MASTER for the ETL master repository
- BCAN_DWH for the data warehouse
- The user who connects to these databases during the installation must have complete control of the databases. Grant the user the following permissions:
- create tables
- create views
- create functions
- create stored procedures
- Verify that the user can log on to the databases and perform these actions.
To enable the TCP/IP port
Verify that the TCP/IP port is enabled to connect to the database host machine. If the TCP/IP port is not enabled, enable it.
- Select Start > All Programs > Microsoft SQLServer version > Configuration Tools > SQL Server Configuration Manager.
- In Sql Server Configuration Manager, click SQL Server Network Configuration > Protocols for instanceName.
- In the details pane, verify that status of TCP/IP is Enabled.
To configure security
SQL Server security must be configured in mixed mode. In the SQL Server Security area, choose SQL Server and Windows Authentication mode.
To verify the database server setup
Before beginning the installation, confirm the following database server requirements:
- The database server must be accessible from the reporting and application servers in your deployment.
- Ensure that the drivers used by the BusinessObjects Business Intelligence server are compatible with your database setup (see Setting up the reporting server).
- Ensure that there are no port conflicts.