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.
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 SMP 7 to access the its 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; If the Altiris database does not already exist, then this account need 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 backup and restore
- table re-indexing
- file defragmentation
- Creating a maintenance plan in SQL Server 2005 or 2008 to optimize database performance (HOWTO8589)
- Optimizing SQL Server 2005 on Windows Server 2003 32-bit (49632)
- How to create a Performance Monitor counter set for Altiris support (32258)
- Common Performance Monitor counter thresholds (45425)
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.