#1 2017-10-12 14:54:54

eike.welk
Member
Registered: 2017-10-12

Can't install MSSQL driver

I have problems to install the drivers for MS-SQL.

I have installed Report Server Enterprise (64 bit) with the installer from Bitnami.

I have copied the file:
    jtds-1.3.1.jar
to:
    C:\Bitnami\reportserverenterprise-3.0.2-7\apache-tomcat\webapps\reportserver\WEB-INF\lib

I have created a file:
    C:\Bitnami\reportserverenterprise-3.0.2-7\apache-tomcat\webapps\reportserver\WEB-INF\classes\persistence.properties
which contains the following lines:
    # SQL Server
    hibernate.dialect=net.datenwerke.rs.utils.hibernate.SQLServer2008Dialect
    hibernate.connection.driver_class=net.sourceforge.jtds.jdbc.Driver
    hibernate.connection.url=jdbc:sqlserver://192.168.1.46\tdb;databaseName=DevDB

I have restarted the application with the manager tool.

However in the Datasources Manager the MsSql driver is reported as missing.

If I test a connection I get the following error:

net.datenwerke.rs.core.service.reportmanager.exceptions.DatabaseConnectionException: Could not open connection to: jdbc:jtds://192.168.1.46\tdb;databaseName=devdb with user: developer_dummy. Driver not found: com.microsoft.sqlserver.jdbc.SQLServerDriver
<br>    at net.datenwerke.rs.base.service.datasources.transformers.database.Database2TableTransformer.transform(Database2TableTransformer.java:57)
...
...

What am I doing wrong?
Is there a detailed description which I could follow?

Offline

#2 2017-10-12 16:47:04

jalbrecht
Administrator
Registered: 2016-10-21

Re: Can't install MSSQL driver

Hi Eike,

there is two steps:

1. copy the resp. jdbc driver in the reportserver/WEB-INF/lib/ folder, in the bitnami installer case: \Bitnami\reportserverenterprise-3.0.2-6\apache-tomcat\webapps\reportserver\WEB-INF\lib. I use sqljdbc42 but from what i hear MS put out version 6 already: https://www.microsoft.com/de-de/downloa … x?id=11774

2. use the correct URL
here is a forum post, that at the very end of it , might give you an idea with the URL: https://forum.reportserver.net/viewtopic.php?id=117
Anyway it helps to check here: https://reportserver.net/en/documentation/

and search for whatever might cause trouble.

Pls.  do not hesitate to contact us in case of any questions.

wbr jan

Offline

#3 2017-10-18 11:09:16

eike.welk
Member
Registered: 2017-10-12

Re: Can't install MSSQL driver

Hello Jan!

Thank you very much, it works. Getting the server URL right is somewhat tricky. I document the whole recipe here for posterity:

This writeup is about configuring access to an MS-SQL server for Reportserver Enterprise on Windows 7. The recipe also works with the community version, however the file names are slightly different.

Reportserver Enterprise is installed with an Installer from Bitnami.


Install the Driver
------------------

Download the Windows installer (the *.exe file) from:
    https://www.microsoft.com/de-de/downloa … x?id=11774

This is really an self-extracting archive. Extract it anywhere. In the exacted archive locate the file sqljdbc42.jar.

Copy
    sqljdbc42.jar
to
    C:\Bitnami\reportserverenterprise-3.0.2-6\apache-tomcat\webapps\reportserver\WEB-INF\lib

Restart Reportserver.


Enter the Database Server's URL
-------------------------------

The URL of the SQL server is entered in:
    Administration->Data Sources [->new->relational database]

The URL depends on the exact options used for the MS-SQL server. The following site was helpful for determining the correct URL:

    https://docs.microsoft.com/en-us/sql/co … ection-url

For an MS-SQL Server 2014 that uses dynamic ports the URL has the following form:

    jdbc:sqlserver://;servername=<server_name_or_IP>\<instance>;database=<database_name>

I use:
    jdbc:sqlserver://;servername=SRV-001-046\TDB;database=DevDB

Last edited by eike.welk (2017-10-18 12:26:37)

Offline

Board footer

Powered by FluxBB