Before installing a SQL agent (collector), check Precise for MS-SQL requirements.

If the SQL instance is part of a SAP or PeopleSoft application, check the full installation guide for further details.

Internationalization

To facilitate SQL Server Internationalization, verify that:

• the locale of the PMDB, FocalPoint, PMDB instances, and servers with monitored SQL instances are valid (and are the same for all servers),
• the instance and database collation of the PMDB and monitored SQL instances are the same, and support chosen locale, and
• the PMDB database is case sensitive.

Adding a SQL instance for monitoring

To add a SQL instance for monitoring

1. From the AdminPoint tab, select Installation.
2. Click Add in the bottom right-hand corner, as shown in the following image.