JDBC connection to MS SQL Server

Question

Getting the following error when trying to connect to a Microsoft SQL Server 2014.

I have downloaded the JDBC drivers from Microsoft added the path to the .jar to my PATH variable.

I've also tried restarting, addressing the server by Server name, Fully Qualified Domain Name and IP address. Per another question I have also tried moving the mssql-jdbc-6.2.0.jre8 file to the LIB directory of Knowage with no luck.

Driver not found: jdbc:sqlserver://172.16.2.22;databaseName=DATA;

Appreciate the support!

Answer 1

Hi,

    I can connect to SQL Server 2014 putting sqljdbc41.jar in <Tomcat root>/lib. sqljdbc41.jar is for Java 7 and should work with SQL Server 2016 too. Please check https://www.microsoft.com/en-US/download/details.aspx?id=11774 for other drivers.

The resource in <Tomcat root>/conf/server.xml is something like that:

<Resource auth="Container" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" maxActive="20" maxIdle="10" maxWait="-1" name="jdbc/ds_cache" password="..." type="javax.sql.DataSource" url="jdbc:sqlserver://localhost:1433;databaseName=ds_cache" username="..."/>

Please set attributes name, url, password & username properly.

Best regards,

Francesco

Comments

I've followed these the instructions carefully, and I'm still getting the same error rnowakowski experienced. I've copied mssql-jdbc-6.2.2.jre7.jar and mssql-jdbc-6.2.2.jre8.jar to the <>/Knowage-Server-CE/lib directory and ensured the were executable.

I did not find the string you mentioned above in <>/Knowage-Server-CE/conf/server.xml

is this not configurable through the GUI?

---

You should pick up one and only one JDBC driver in your Knowage-Server-CE/lib, depending on the installer JDK (1.7 or 1.8). Please remove the wrong one and reboot Knowage.

---

Giving that a try right now.

---

That did not work. Where do I find the log files so I can upload them here?

---

or more accurate which of these logs would be most useful to you?

ubuntu@xxxx:/var/www/Knowage-Server-CE/logs$ ls
knowageQbeEngineAudit.log
knowageQbeEngine.log
knowageTalendEngine.log
host-manager.2018-03-12.log
host-manager.2018-03-16.log    
host-manager.2018-03-20.log    
knowage_[1]_OperatorTrace.log  
knowageBirtReportEngine.log    
knowageDataMiningEngine.log    
knowageDatasetAudit.log       
knowageGeoReportEngine.log     
knowagejasperreportengine.log  
knowage.log                    
KnowageMeta.log                
manager.2018-03-16.log
manager.2018-03-20.log
knowageNetworkEngine.log       
Quartz.log

---

Cantina.out

https://www.knowage-suite.com/qa/?qa=blob&qa_blobid=9362793411887085046

Knowage.log

This was empty... I was trying to find where I could set verbose logging. I'll upload it once I figured that out.