Geneos - How to solve login issues in SQL-Toolkit plugin

Account and Password Status

Database accounts can sometimes be locked due to password expiry or other issues. User should check that the username and password is correct with the database's command line.

We are providing examples for some common databases below. Please kindly refer to the database vendor documentation for details.

• mysql (for MySQL)

mysql --user=<username> --password <database name>

• sqlplus (for Oracle)

sqlplus <username>@<database name>

(Command will prompt for the password)

• isql (for Sybase ASE)

isql –S <servername> –U <username> -P <password>

Netprobe and Database Client compatibility

If there had been changes with the database server or operating system, please check that the Netprobe and database client are compatible and up to date. Sometimes changes in SSL / TLS settings will also require upgrade of the Netprobe and database client.

There is another article with pointers on this topic: How to solve database client installation issues in SQL-Toolkit plugin.

Windows Netprobe and MS SQL Server

The Netprobe is usually started as a Windows service, which is running as Local System account by default. If the username and password are not set in the SQL-Toolkit sampler, the Netprobe will connect using the service user's credentials. The following shows a generic error message when similar error occurs.

Fail - 42000 Login failed for user. (18456)

Please check with the DBA on the database's authentication mechanism and permission settings.

Older Netprobe GA3.x Versions

Netprobe in the older GA3.x versions did not support password encryption in AES format. If the password in Gateway Setup Editor is entered as AES format, the Netprobe should be upgraded to a supported version of GA4.x and GA5.x. (our reference: AA-768 and COL-1619).