Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Microsoft(R) SQL Server


KAVF21810-E

An attempt to connect to SQL Server failed. ("Microsoft-SQL-Server-detailed-error-information")

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 Agent Collector service processing.

(O)

Check the following items:

  • Microsoft SQL Server has been started.

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

    - Microsoft SQL Server instance name

    - SQL_HOST (monitored host-name)

    - SQL_USER (user-name)

    - SQL_PASSWORD (password)

    - DRIVER_NAME (driver name)

If this item is incorrectly specified, cancel setup of the instance environment, and then set up the instance environment again with a correct instance name.

If the items entered during setup of the instance are incorrect, update the instance 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 - Agent 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 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.