Creating Microsoft SQL Server database and database user

When you create Microsoft SQL database and database user for use with IBM® Sterling Control Center Monitor, ensure that you configure the settings required for operation with IBM Sterling Control Center Monitor.

Before you begin

Install the Microsoft SQL Server database server. When you install the server, accept the following settings:
  • Collation Setting as SQL_Latin1_General_CP1_CI_AS or Latin1_General_CI_AS
  • Server Authentication as SQL Server and Windows Authentication Mode
Also, ensure that you have the authority to create the database and database users.

About this task

Create the database with the required settings outlined in Required settings for Microsoft SQL Server database and database user.

Procedure

  1. Create and configure a Microsoft SQL Server database instance with the required settings.
    Use SQL_Latin1_General_CP1_CI_AS or Latin1_General_CI_AS as the Collation Setting when creating the instance.
  2. Create a database.
  3. Create user.
  4. Grant permissions to the user.