-
Title
Verify Connection Error - No suitable driver found for jdbc:db2 -
Description
For Windows 2008 Server where Stat Central Agent installed. While running Stat Central Agent as Windows services. When attempt to perform test connection from Stat Web Client for Databases, get error "Verify Connection Error - No suitable driver found for jdbc:db2". However, it works fine if Stat Central Agent was running as run.bat file.
-
Cause
This issue is specific to windows 2008 server and only when you run Stat central agent as windows service. Windows 2008 has added another layer of security for running as services. The user id does not have to be administrator.
-
Resolution
1. Go to Start-->Administative tool-->Local security policy-->User Right Assignment
2. Look for Log on as a service policy
3. Right click this policy for Properties ->Local Security Setting->Add User or Group. In my case, I've added a user called Stat that is part of the Admin group
4. Go to Start-->Administative tool-->Services-->Stat Agent->properties->Log On->This Account. Enter the username/password to startup the stat agent.