Connection issue with SQL Server 2016 from Neon [message #1778058] |
Fri, 08 December 2017 14:01  |
Eclipse User |
|
|
|
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!)
|
|
|
|
Powered by
FUDForum. Page generated in 0.24046 seconds