Creating Data Adapter for Microsoft SQL Server 2017 Express

[tblake]

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.

Thanks!

[omarquinigo]

I have the same problem here, help please!