Skip to main content
josephw77476538
josephw77476538
Participant
September 30, 2021
Question

Unable to create a DSN to sql server.

  • September 30, 2021
  • 2 replies
  • 967 views

Hello I am using coldfusion 2021 community and sqlserver 2014 on a windows 10 machine. I have not been able to create a DSN, receiving different errors the latest error being  Connection verification failed for data source: food_09292021
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Kerberos Authentication is not supported by this SQLServer. The driver attempted Kerberos authentication because the AuthenticationMethod connect option was "auto" and no username/password was specified.

Thank you in advance for your help

    2 replies

    Charlie Arehart
    Community Expert
    Charlie ArehartCommunity Expert
    Community Expert
    February 14, 2022

    The issue is that the progress/datadirect JDBC driver which CF implements had a change in behavior (in the version of the driver which took effect in CF2021), and now "ntlm" is no longer one of the "auto" options for authentication.

     

    Btu good news: you can get this password-less ("trusted") connection working by implementing a connectionstring (in the CF Admin DSN "advanced settings") with a value of: 

     

    AuthenticationMethod=ntlm

    /Charlie (troubleshooter, carehart. org)
      BKBK
      Community Expert
      BKBKCommunity Expert
      Community Expert
      February 15, 2022

      Charlie's suggestion should work (judging by the results of googling "Kerberos Authentication is not supported by this SQLServer").  In fact, here is a similar forum thread.

       

      However, in the unlikely event that it doesn't, then try adding the SQL Server domain to the connection string. That is, something like this (bkbkDomain is my domain name; use yours instead):

       

      domain=bkbkDomain;AuthenticationMethod=ntlm

       

       If you don't know your SQL Server domain, the following query might help:

       

      SELECT DEFAULT_DOMAIN()

       

      Priyank Shrivastava.
      Community Manager
      Priyank Shrivastava.Community Manager
      Community Manager
      September 30, 2021

      Hi,

       

      Enable SQL authentication in your SQL server and create username and password. Use the same credentials to create the DB connection in ColdFusion.

       

      Thanks, Priyank Shrivastava
      BKBK
      Community Expert
      BKBKCommunity Expert
      Community Expert
      September 30, 2021

      Having a look at the picture in the following Stackoverflow answer might help: https://stackoverflow.com/questions/42420529/coldfusion-is-not-connecting-datasource-with-sql-server-2014 

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