You can translate the question and the replies:

Connecting MS SQL Server through Denodo Testing tool throws error.

I'm trying to establish a connection to SQL Server using the below properties through config file. mssql.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver mssql.jdbcUrl=jdbc:sqlserver://sqlsrv- devtest.database.windows.net:1433;databaseName=testdw; mssql.dbAdapter=sqlserver-8.4.1 mssql.username=devtest mssql.password=xxxxxxxxxxx. The connection ends up with an error. Test raised an unexpected java.lang.RuntimeException: Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl The above mentioned jdbc url works perfectly when launched through Ms sql server management studio and VDP but not sure why the error occurs. Please help
SQL SQL Server
user
14-10-2020 14:20:35 -0400
code

3 Answers

Hi, I was able to set up Microsoft SQL Server database in the configuration file and I could run test scripts successfully. In case of any errors, you could check the following : 1. Check if you have placed the Microsoft SQL Server [**JDBC Driver**](https://community.denodo.com/docs/html/browse/latest/vdp/administration/appendix/supported_jdbc_data_sources/supported_jdbc_data_sources#supported-jdbc-data-sources) jar file into the **<TESTING_TOOL_HOME>/lib/sqlserver-8.4.1** folder. 2. Make sure the specified JDBC URL is correct and the host is reachable. 3. You can also check **testing-tool.log** under **<TESTING_TOOL_HOME>/log** folder for more information. Additionally, if you still need help and if you are a user with valid support access then you can raise a support case in Denodo Support Site so that our support team can help you. Hope this helps!
Denodo Team
15-10-2020 07:07:41 -0400
code
SQL server drivers are placed in the testing tool driver folder and all other steps mentioned above were done. Below is the error: Missing configuration parameter 'mssql.driverClassName' Below are the connection details used: mssql.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver mssql.jdbcUrl=jdbc:sqlserver://sqlsrv- devtest.database.windows.net:1433;databaseName=testdw; mssql.dbAdapter=sqlserver-8 mssql.username=devtest mssql.password=xxxxxxxxxxx. Please let me know if we are missing out something.
user
31-05-2022 06:03:26 -0400
Hi, The error **Missing configuration parameter ‘mssql.driverClassName’** usually occurs when the property "mssql.driverClassName" is commented in the **configuration.properties** file found under "<TESTING_TOOL_HOME>\conf" directory. To set up Denodo Testing Tool for testing the Microsoft SQL server data sources, you could perform the following: * In the **configuration.properties** file found under "<TESTING_TOOL_HOME>\conf" directory, specify the **DATA SOURCE CONFIGURATION** to point to the Microsoft SQL server instance. * Place the required Microsoft SQL server JDBC driver into the "<TESTING_TOOL_HOME>\drivers\sqlserver-8" folder. You can take a look at the [**Denodo Testing Tool - User Manual**](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20Testing%20Tool%20-%20User%20Manual) for more information. Hope this helps!
Denodo Team
29-06-2022 07:32:33 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here