Error connecting BIRT report to SQL Server.

Applies to: SQL Server 2014.
 

Problem Description.
 

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 connection.



Solution.

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 Manager)


Make sure SQL Server has TCP protocol enabled.  Please follow instructions here.


Configure Windows Firewall to allow SQL Server access (as explained here) or disable Windows Firewall.


Specify the following code on the connection string to get connected using Windows authentication.

jdbc:sqlserver://localhost;integratedSecurity=true;


Try to connect using both, the JTDS driver and using Microsoft JDBC driver (as explained here).


jdbc:jtds:sqlserver://localhost;useNTLMv2=true;

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.