Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Connection issue with SQL Server 2016 from Neon(Can't connect Neon to SQL Server 2016)
Connection issue with SQL Server 2016 from Neon [message #1778058] Fri, 08 December 2017 19:01 Go to next message
Jeff Stouse is currently offline Jeff StouseFriend
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!)
Re: Connection issue with SQL Server 2016 from Neon [message #1778066 is a reply to message #1778058] Fri, 08 December 2017 21:25 Go to previous message
Jeff Stouse is currently offline Jeff StouseFriend
Messages: 28
Registered: May 2012
Junior Member
Nevermind - figured it out.

Thanks.
Previous Topic:Bar graphs with multiple pages
Next Topic:Cumulative Count
Goto Forum:
  


Current Time: Sun Aug 19 05:52:19 GMT 2018

Powered by FUDForum. Page generated in 0.01886 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top