Skip to main content
jgalea1
jgalea1
Participant
August 8, 2019
Question

Unable to connect to Sql Server 2016 database with ColdFusion 2018

  • August 8, 2019
  • 3 replies
  • 2075 views

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?

    This topic has been closed for replies.

    3 replies

    Priyank Shrivastava.
    Community Manager
    Priyank Shrivastava.Community Manager
    Community Manager
    August 12, 2019

    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
    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    August 12, 2019

    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

    D
    Community Expert
    Dave WattsCommunity Expert
    Community Expert
    August 8, 2019

    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

    Dave Watts, Eidolon LLC
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices