I am trying to connect to external Microsoft SQL server database using QueryData

himanshug over 10 years ago

I am trying to connect to external Microsoft SQL server database using QueryDatabase smart service.I configured the server URL,username,password and required query statement in the setup tab.But this is giving me below error -
(RDBMS Validation)
Errors
There was a problem during the validation of the SQL statement with the database
There was a problem in connecting to database. com.microsoft.sqlserver.jdbc.SQLServerDriver from [Module "deployment.suite.ear:main" from Service Module Loader]

Can anyone help me to get out of this....

Discussion posts and replies are publicly visible

0 Sathya Srinivasan
Appian Employee
over 10 years ago

Make sure you have the driver in the correct location. (see forum.appian.com/.../Configuring_Relational_Databases)
Ideally, you should try to create a JNDI configuration where the connection is established instead of manually entering the secure credential at design time. I suggest you take that approach.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel