jdbc_response connection failure from Linux to Windows

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

You are attempting to monitor a Windows-based SQL Server using the jdbc_response probe running on a Linux robot.

You are using a Windows/Domain user for authentication.

You receive a "login failed" message even though the credentials are correct.

Environment

DX UIM - Any Version
jdbc_response probe - all versions

Cause

Compatibility

Resolution

It is only possible to use Windows/Domain authentication on this probe when it is installed on a Windows robot.

The reason for this is that it is necessary to provide the Log On credentials for the Nimsoft Robot Watcher Service to allow the database login to succeed using Integrated Authentication.  It is only possible to credential the Nimsoft Robot Watcher Service in this manner when using a Windows Robot.  Linux Robots do not have this capability.

In order to monitor a Windows MSSQL Server using jdbc_response in Linux, there are two options:

1. Use SQL Authentication (e.g. the "sa" or similar SQL User) instead of Windows/Domain authentication
2. Install the probe on a Windows robot

 

Additional Information

JDBC Response Troubleshooting