Notes on configuring SQL Server for use with SMP 7 or later

book

Article ID: 179741

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

Question

You are installing and/or configuring SQL Server for use with the Symantec Management Platform (SMP) and you need to know what is expected from the SQL server.

Environment

ITMS 7.x, 8.x

Resolution

Answer
The Symantec Management Platform (SMP) stores much of its data in a Microsoft SQL Server database. This article describes many of the expectations about the SQL Server is configuration. The Symantec Management Platform (SMP) is the underlying core framework of the Altiris 7 product line. This article specifically discusses SMP 7.0 SP4. While this information specifically applies to SMP 7, it also applies to many of Altiris 7 solutions (in whole or in part). Please note, some solutions have additional requirements.

 


Supported versions of SQL server:

For current supported versions of SQL Server and additional details, please review:


Where to install SQL server:

 

The SMP can use an SQL Server installed on the same computer or on a different computer. For additional information about recommended configuration see:

 


SQL Server, Database, and Account Credentials

The SMP 7 stores information on one SQL server; in one database, using one schema. The default database name is Symantec_CMDB. The SMP 7 can authenticate to the SQL Server using either a Windows account, or SQL Server login.

The SMP 7 uses one set of credentials for most activities. It can also a second set of credentials to produce public reports. These credentials can be either:

  • the Altiris Application Identity (the Windows account that is used to run the Altiris services on the Notification Server), or
  • an SQL server login.

The name of the SQL server, the name of the database and the account credentials can be specified during installation, using Symantec Installation Manager (SIM); and can be viewed and/or modified using the Symantec Management Console (SMC). see: Settings > All Settings; then Settings > Notification Server > Database Settings; then General (tab).

Warning: changing these settings in the SMC does NOT move or copy the database, and may cause the loss of access to the Altiris database.

 


SQL Server Account Permissions

The account used in SMP 7 and later to access the database needs permissions to modify the Altiris database, including:

  • create, alter, and drop tables
  • create, alter, and drop views
  • create, alter, and drop stored procedures
  • execute stored procedures
  • view, insert and drop records in these tables.

Additionally, this account needs to:

  • view information from the msdb database
  • execute some system stored procedures.

Additionally, when the the Symantec Installation Manager (SIM) is installing SMP 7 or later; If the Altiris database does not already exist, then this account needs to be able to create the Altiris database.

For additional information See:


Database Purging The SMP, and many of the solutions can store historical information in the database. This data will remain in the database until it is explicitly purged. An Altiris Administrator can enable schedule a task to purge the database of information older than a specified amount of time. See:


Database Maintenance

  • database backup and restore
  • table re-indexing
  • file defragmentation

Maintaining the database can be accomplished using the built-in capabilities of SQL Server. In some situations some 3rd party applications may be helpful. Please note, that the SMP does not include any utilities to accomplish these maintenance tasks. For additional information see:

Additionally, the Altiris database needs to be appropriately maintained. This includes (but is not limited to)


Recommended Database Settings:

We recommend that the following settings on the Symantec_CMDB database:

  • set Recovery Model to Simple
  • enable autogrowth, and set the growth increment to 10%
  • disable autoshrink
  • leave Collation at the default, which is Latin1_General_CI_AS.