This article provides general guidelines to investigate login issues with the 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 --user=<username> --password <database name>(Command will prompt for the password)
sqlplus <username>@<database name>
(Command will prompt for the password)
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).
Please sign in to leave a comment.