ReportServer Forum

sakunthala

Member

Registered: 2024-04-17

SQL Server(driver missing)(Microsoft JDBC driver for SQL Server(MSSQL)

I am using ReportServer enterprise-4.6.3.6104 and SQL server 2022. OS- Windows 11. I want to connected to my SQL server from ReportServer. But in the Databases drop down SQL server shows as "SQL Server (driver missing) (Microsoft JDBC driver for SQL Server(MSSQL))"
I followed below steps but It was not resolved. Please guide me to resolve this issue. Thank you!

downloaded JDBC driver from https://www.microsoft.com/en-US/downloa … x?id=11774
copied   to
1 st check
C:\infofabrik\reportserverenterprise-4.6.3.6104-0\apache-tomcat\webapps\reportserver\WEB-INF\lib

2nd check
C:\infofabrik\reportserverenterprise-4.6.3.6104-0\apps\reportserver\reportserver-conf\lib

changed persistence.properties file,
(C:\infofabrik\reportserverenterprise-4.6.3.6104-0\apps\reportserver\reportserver-conf\persistence.properties)
# SQL Server
hibernate.dialect=net.datenwerke.rs.utils.hibernate.SQLServer2022Dialect
hibernate.connection.driver_class=com.microsoft.sqlserver.jdbc.SQLServerDriver
hibernate.connection.url=jdbc:jtds:sqlserver://localhost:61806/<DBName>
hibernate.connection.username=<username>
hibernate.connection.password=<password>

restart the services "reportserverenterpriseApache" and "reportserverenterpriseMariaDB" and checked

Last edited by sakunthala (2024-04-17 12:19:33)

IF_Adrian

Member

Registered: 2021-10-29

Re: SQL Server(driver missing)(Microsoft JDBC driver for SQL Server(MSSQL)

Hi,

There are two thing you should differentiate.
1. persistence.properties
-> This file declares, which database is used for ReportServers internal objects such as reports, users, datasinks, etc
2. (presumably) The Database drop down is a Datasource -> Relational Database object
-> This is like a declaration for a Database connection which is used to access external data

Do you want to migrate your ReportServer to a another database (SQL-Server)
or do you want to declare a new Datasource-Object ( SQL-Server for which the driver is missing)?

Kind regards,
Adrian

sakunthala

Member

Registered: 2024-04-17

Re: SQL Server(driver missing)(Microsoft JDBC driver for SQL Server(MSSQL)

Hi Adrian, I  want to declare a new data source object to access external data (MS SQL-Server for which the driver is missing)
Thank you

sakunthala

Member

Registered: 2024-04-17

Re: SQL Server(driver missing)(Microsoft JDBC driver for SQL Server(MSSQL)

Resolved this. Issue was in the jdbc driver version

copied mssql-jdbc-12.6.1.jre11.jar  to C:\infofabrik\reportserverenterprise-4.6.3.6104-0\apache-tomcat\webapps\reportserver\WEB-INF\lib

restart following services

reportserverenterpriseTomcat - Apache Tomcat 9.0 jasperreportsTomcat

reportserverenterpriseApache

Thank you

Last edited by sakunthala (2024-04-22 05:22:40)

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: SQL Server(driver missing)(Microsoft JDBC driver for SQL Server(MSSQL)

Hi sakunthala,

thank you for sharing your solution!

Regards,
Eduardo