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
- Collation Setting as SQL_Latin1_General_CP1_CI_AS or Latin1_General_CI_AS
- Server Authentication as SQL Server and Windows Authentication Mode
About this task
Procedure
- 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.
- Create a database.
- Create user.
- Grant permissions to the user.