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?
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
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
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