Unable to connect to Sql Server 2016 database with ColdFusion 2018

[jgalea1]

We're getting the following error when trying to add a new data source connection from CF 2018 to SQL Server 2016 Database:

Connection verification failed for data source: LocalInternationalServicesMssql2016

java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'InternationalServices-DEV'.

The root cause was that: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'InternationalServices-DEV'.

Does anyone have a resolution to this connection error?

[Dave Watts]

There are a couple different possibilities here. One is that SQL Server isn't configured to accept connections via TCP/IP. There's a blog post here about that, but I don't think it's your problem based on the exact error message you're getting.

https://www.carehart.org/blog/client/index.cfm/2006/7/8/sql2k5_Error_establishing_socket

Another is that SQL Server is configured to use Windows authentication, and not "native" authentication where you can pass a username and password.

Change Server Authentication Mode - SQL Server | Microsoft Docs

Dave Watts, Eidolon LLC

[BKBK]

The most likely cause is: incorrect username/password combination. Verify, away from ColdFusion, for example, using SQL Server Management Studio, whether you can log in to the database with the username InternationalServices-DEV

[Priyank Shrivastava.]

Hi,

Could you please share more details on where is your MS SQL server, is it on Azure cloud or installed locally.

Also, are you using SSL connection or non-ssl?

Thanks,

Priyank Shrivastava