Using MS SQL Server as a Data Source in JasperReports Server

This functionality is no longer applicable to our latest version. 

MS SQL Server is one of the default Data Sources of JasperReports Server. 

Please look at the actual documentation: JasperReports® Server Administrator Guide 8.2.0
Follow the link here and look for chapter 4 - data sources - page 75

Summary

This page describes how to connect JasperReports Server to your Microsoft SQL Server Database as a datasource for your reports.

Steps

As described in Connection JasperReports Server to your Database, datasources that connect to a relational database can be set up as either:

• JDBC Datasources, or
• JNDI Datasources

Setting up a JDBC Datasource

The basic steps for establishing a JDBC Datasource are as follows:

1. Confirm that you can reach your database
2. Download and install the JDBC Drivers for your Database into JasperReports Server
3. Restart JasperReports Server
4. Login to JasperReports Server
5. Go to the Repository. Right click on the folder where you would like to create your Datasource object and select Create Datasource
6. Select JDBC as the Datasource type
7. Enter your Driver Class, Connection URL, DB username and passord
8. Click Test Connection
9. Save
10. Begin deploying reports and connecting them to this datasource or use this datasource to create domains to support ad hoc views.

The following video shows the details of establishing the MS SQL Server Datasource: