Highlighted

Unable to connect to Sql Server 2016 database with ColdFusion 2018

New Here ,
Aug 08, 2019

Copy link to clipboard

Copied

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?

Views

541

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Unable to connect to Sql Server 2016 database with ColdFusion 2018

New Here ,
Aug 08, 2019

Copy link to clipboard

Copied

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?

Views

542

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Aug 08, 2019 0
Adobe Community Professional ,
Aug 08, 2019

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 08, 2019 0
Adobe Community Professional ,
Aug 12, 2019

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 12, 2019 0
Adobe Employee ,
Aug 12, 2019

Copy link to clipboard

Copied

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

Thanks,
Priyank Shrivastava

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 12, 2019 0