Jump to content

Creating Data Adapter for Microsoft SQL Server 2017 Express


Recommended Posts

Hi all, could you spare a moment to help a newbie set up a data adapter?

I'm attempting to set up a data adapter to connect to a database on my computer created with Microsoft SQL Server 2017 Express, but whenever I click "Test" Jaspersoft Studio begins processing and never stops. I do not recieve any kind of error message, as the process never ends. Does anyone know what would cause this kind of behavior?

To set this up, I've taken the following steps found online:

  • Download the latest Microsoft JDBC Driver for SQL Server
  • Download and install the latest version of OpenJDK
  • Set the Driver Classpath to point to the driver's .jar file

The fields in the Data Adapter Wizard are filled as follows:

JDBC Driver: MS SQLServer (2005-2012) (com.microsoft.sqlserver.jdbc.SQLServerDriver)
JDBC Url: jdbc:sqlserver://localhost:1433;databaseName=MY_DATABASE
Username: [my username]
Password: [my password]

I'm still too new to this to know what other information might be helpful, so please let me know if there's anything else I can provide.


Link to comment
Share on other sites

  • 8 months later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...