Skip to main content



      Home
Home » Archived » 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 14:01 Go to next message
Eclipse UserFriend
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 16:25 Go to previous message
Eclipse UserFriend
Nevermind - figured it out.

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


Current Time: Sun Jul 13 08:48:58 EDT 2025

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

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

Back to the top