You are not logged in.
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)
Offline
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
Offline
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
Offline
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)
Offline
Hi sakunthala,
thank you for sharing your solution!
Regards,
Eduardo
Offline