Eclipse Community Forums: BIRT » Connection issue with SQL Server 2016 from Neon

Help

Home

Home » Archived » BIRT » Connection issue with SQL Server 2016 from Neon(Can't connect Neon to SQL Server 2016)

Show: Today's Messages :: Show Polls :: Message Navigator

Connection issue with SQL Server 2016 from Neon [message #1778058]

Fri, 08 December 2017 19:01

Jeff Stouse

Messages: 28
Registered: May 2012

Junior Member

OK,
SQL Server 2016 set to accept remote connections; Windows firewall configured to allow inbound connections over port 1433 (which is what SQL Server is set to talk over.)
SQL Server 2016 set to accept either Windows or SQL accounts.

Using JRE 1.8 and sqljdbc42.jar
Data Source in Neon BIRT:
Driver Class: sqljdbc42.jar
connection string: (URL)
jdbc:sqlserver://sqlexpress01; databaseName=TimeMatters_Tutor
user name: and password - I have used the same username and password combinations that I use to login to SSMS (successfully)- BIRT responds with 18456 Severity 14; error 8 - which is password failure.

Makes no sense - same username and password works with SSMS login - I've tried both Windows login creds and SQL Server creds (making sure that for the databaseNamed there is an appropriate SQL Server login) and still no joy!

What am I doing wrong?

TIA, (I've been at this for a day already - please put me out of my misery!)

Report message to a moderator