MSSQL Configuration Syntax

The MSSQL Configuration is used for monitoring Microsoft SQL Server instances. This functionality part of the Database Server Management product.

SUBSYS MSSQL

[DEFAULT AUTH ({WINLOGON|SQLLOGON})]
ADD SQLSERVER (<PROGNOSIS_Id>, <SqlAddress>[, {WINLOGON|SQLLOGON}])
DATABASE PROVIDER ({OLE_DB|NATIVE_CLIENT})

Syntax Elements

DEFAULT AUTH (Optional)

This statement is used to set a default authentication type. This is used by any of the following ADD SQLSERVER statements that do not contain their own specific authentication details. Enter WINLOGON to perform a Windows authentication or SQLLOGON to perform SQL authentication.

The authentication username and password must be stored in the PASSWORDS Configuration, the PASSWORDS entry must match MSSQL:<PROGNOSIS_ID>, refer to PASSWORDS Configuration.

If the WINLOGON option is selected, the PASSWORDS Configuration for MSSQL must have a username entered in the format domain\username. If domain is not specified, the local domain will be used.
If the DEFAULT AUTH statement is omitted, the authentication method will default to SQLLOGON unless any of the ADD SQLSERVER statements specify otherwise.

ADD SQLSERVER

Add one ADD SQLSERVER statement for each SQL instance to be monitored:

<PROGNOSIS_Id>

This is a unique user-defined name to connect to an SQL Server. This name is used in the PASSWORDS Configuration.

<SqlAddress>

This is the name or IP address of the machine where the SQL Server is installed and will allow monitoring of the default SQL Server instance.

In the case where more than one SQL Server is installed on the same machine, it is necessary to specify <SqlAddress\InstanceName>, where <InstanceName> is the non-default Server instance. For example, if the Windows machine SQL2K5CLS has two SQL Servers installed, one being the default SQL Server instance and the other SQL Server instance being named 'SQLOther', the entry required would be:

ADD SQLSERVER (PrognosisAccess1, SQL2K5CLS\SQLOther)

{WINLOGON|SQLLOGON}

This parameter is optional and is used to indicate how the authentication to the SQL Server should be performed. WINLOGON performs Windows authentication and SQLLOGON performs SQL authentication. If this parameter is omitted the DEFAULT AUTH statement will apply.

DATABASE PROVIDER (Optional)

Configure which database provider to monitor the MSSQL Servers; either OLE DB or SQL Native Client. By default, the OLE DB provider is used. However, if NATIVE_CLIENT is configured, SQL Native Client 11.0 must be installed on this Monitoring Server. The latest SQL Native Client provides support for communication using TLS 1.2.

Example:

The following configuration example includes two SQL Server machines. The first Server does not include any authentication parameter and so will use the DEFAULT AUTH setting, while the second Server includes an authentication parameter (SQLLOGON) and so will not use the default setting.

SUBSYS MSSQL

DEFAULT AUTH (WINLOGON)
ADD SQLSERVER (PrognosisAccess1, SQL2K5CLS)
ADD SQLSERVER (PrognosisAccess2, SQL2K6CLT, SQLLOGON)
DATABASE PROVIDER (NATIVE_CLIENT)
Provide feedback on this article