Error connecting BIRT report to SQL Server.
Applies to: SQL Server 2014.
You may get an error like the following while trying to connect a BIRT report
from the Report Designer to SQL Server:
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get
Please watch the following video about how to connect a BIRT report from the
Report Designer to SQL Server.
BIRT Reports - How to
Connect BIRT to SQL Server
If you installed a named instance of SQL Server, named instances have a dynamic
port (they do not listen on port 1433 by default). When SQL Server Express
Edition is installed, it is installed as a named instance and you can connect to
it using computername\sqlexpress. Try the following article to assign the
instance the 1433 port in case no other instance is using it.
Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration
Make sure SQL Server has TCP protocol enabled. Please follow instructions
Configure Windows Firewall to allow SQL Server access (as explained
or disable Windows Firewall.
Specify the following code on the connection string to get connected using
Try to connect using both, the JTDS driver and using Microsoft JDBC driver (as