Creating a Microsoft SQL Server database for BMC Atrium DIL and BMC Dashboards for BSM application server

Use this procedure to create a Microsoft SQL Server database that will store the BMC Atrium DIL database caching information and the configuration information for the BMC Dashboards for BSM application server. If you plan to create the BMC Atrium DIL database using Microsoft SQL Server in a high-availability environment, you must create the database and add the user before installing BMC Dashboards for BSM. Additionally, if you plan to create a clustered BMC Dashboards for BSM application server, you must also create a separate schema to store the configuration data.

As a Microsoft SQL Server database administrator, perform the following tasks of creating the database and adding the user.

To create a Microsoft SQL Server database and database user for BMC Atrium DIL

1. Using the SQL Server Management Tool, create a Microsoft SQL Server database by using the following recommendations and by following the procedures documented in the SQL Server documentation:
   • Evaluate the volume of data to provide the appropriate sizing and extension policy for some of the tablespaces.
   • The size of the tablespaces should be appropriate for the amount of data in the BMC Remedy AR System database.
   • The database will not have the same volume of data as the BMC Remedy AR System database, but it can substantially grow.
2. Create a user in the new database that has the following privileges:
   • Alter on schema
   • Create table
   • Select
   • Insert
   • Delete
   • Update
   • References

To create a Microsoft SQL Server database and database user for BMC Dashboards for BSM application server

1. Using the SQL Server Management Tool, create a Microsoft SQL Server database by using the following recommendations and by following the procedures documented in the SQL Server documentation:
   • Evaluate the volume of data to provide the appropriate sizing and extension policy for some of the tablespaces.
2. Create a user (separate from the BMC Atrium DIL database user) in the new database that has the following privileges:
   • Alter on schema
   • Create table
   • Select
   • Insert
   • Delete
   • Update
   • References