ReportServer Forum

hannidraidi

Member

Registered: 2016-09-08

Connecting to a remote SQL Server Database

I am trying to add a remote SQL Server database as a datasource in datasources page. However, "Driver Missing" appears near MsSQL, and when I fill the database parameters, and test the connection, I get the following error:

Could not open connection to: ptax.com with user: hani. Driver not found: com.microsoft.sqlserver.jdbc.SQLServerDriver

How can I add the driver?

Many Thanks,
Hani

Thomas Davies

datenwerke

Registered: 2016-05-18

Re: Connecting to a remote SQL Server Database

Hello Hani,

welcome to the forum. You can get the SQL Server jdbc drivers from https://www.microsoft.com/en-US/downloa … x?id=11774. Probably the sqljdbc_4.2.6420.100_enu.tar.gz is the right one for you. Within the package you should find a file called sqljdbc42.jar. In order to install the driver, you need to copy this to ReportServer's lib directory. If you used the bitnami installer, then this would be INSTALL_DIR/apps/reportserver/reportserver-conf/lib. After restarting the server, ReportServer should not show the "Driver Missing" info any longer which means that the driver is ready for use.

Hope this helps.

Best Regards,
Thomas

hannidraidi

Member

Registered: 2016-09-08

Re: Connecting to a remote SQL Server Database

Thanks a lot Thomas,

I tried it and it worked well!
What about the Oracle Driver?

Thomas Davies

datenwerke

Registered: 2016-05-18

Re: Connecting to a remote SQL Server Database

Same game. The driver is shipped with your version of oracle or you can get the driver from http://www.oracle.com/technetwork/datab … 80470.html. The driver for you is probably ojdbc7.jar.