KAVL19810-E

An error occurred during an attempt to connect to Microsoft SQL Server. The Microsoft SQL Server detailed error information is an error code returned by Microsoft SQL Server. If Microsoft SQL Server also returns a message for the error code, the message is also displayed.

(S)

Continues Remote Monitor Collector service processing.

(O)

Check the following items:

• Microsoft SQL Server has been started.

• The following items entered during setup of the monitoring target are correct.

  - TARGET_HOST (monitored host-name)

  - SQL_INSTANCE (Microsoft SQL Server instance name)

  - SQL_USER (user-name)

  - SQL_PASSWORD (password)

  - DRIVER_NAME (driver name)

  If the items entered during setup of the monitoring target are incorrect, update the monitoring target by specifying the correct information.

  If there is an error in the DRIVER_NAME setting, the following message is displayed in the "Microsoft-SQL-Server-detailed-error-information".

  rc = IM002 Description = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

• If an alias is specified on the PFM - RM host by using SQL Server Client Network Utility or any other tool, make sure that the following settings are made:

  - The alias settings are correct.

  - A 64-bit alias is specified.

For details about alias setting, see 2.1.4(2)(e) Notes when a non-default Microsoft SQL Server port number or the named pipe protocol is used to connect with Microsoft SQL Server or 3.3.1(5) Notes when a non-default Microsoft SQL Server port number or the named pipe protocol is used to connect with Microsoft SQL Server.

If the alias settings and all items specified during setup of Microsoft SQL Server are correct, correct the error indicated by the error code. For details about Microsoft SQL Server error codes, see your Microsoft SQL Server documentation.