17 Replies Latest reply on Jul 10, 2017 9:35 AM by halbob

    setting up dsn for sql server 2016

    occasionalcoder Level 1

      When I try to connect Coldfusion 2016 to SQL Server 2016, I get the following message:

       

       

      Connection verification failed for data source: xxxx
      java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'xxxx'.
      The root cause was that: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'xxxxx'.

       

      In SQL Server, I have SQL Server Browser running, SQL Server is set up for TCP/IP, and port set at 1433.

       

      In ColdFusion Administrator, I have server set as 127.0.0.1 and port set at 1433. In otherwords, everything that I could find on the net has been tried and I still get the same error message.. I've even tried various passwords i have associated with my computer/microsoft/coldfusion, etc....nothing seems to work.

       

      Any help is greatly appreciated.

       

      Thanks

      Satch