Creating SQL Server databases and setting up the database server

This topic describes how to set up and configure an SQL Server database for a TrueSight Network Automation - Data Warehouse installation. For information about the databases supported for use with Network Automation - Data Warehouse, see System-requirements.

While setting up the database described in these instructions, record the database parameter values. You are prompted for the database parameter values during the Network Automation - Data Warehouse installation.

To create the SQL Server database

1. On the database server, create a database (for example, BCAN_DWH) for the data warehouse.
   Use the following guidelines for the database name and password:

   Warning

   Important

   • If you are creating database with any other name, do not use any special characters in the name.
   • Database password cannot contain more than 16 characters
   • Database password cannot contain any special characters, such as the following:
     • Exclamation mark (!)
     • Ampersand symbol (&)
     • Dollar symbol ($)
2. The user who connects to the database during the installation must have complete control of the database. Grant the user the following permissions:
   • control
   • create tables
   • drop
   • truncate
   • create views
   • create functions
   • create stored procedures
   • login
3. Verify that the user can log on to the database 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.

1. Select Start > All Programs > Microsoft SQLServer version > Configuration Tools > SQL Server Configuration Manager.
2. In Sql Server Configuration Manager, click SQL Server Network Configuration > Protocols for instanceName.
3. 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 there are no port conflicts