2

I have Coldfusion 11 installed on my Laptop (Windows 8.1 Pro) and MS SQL Server 2014 but unable to get them talking to one another. Here are the three screenshots for your reference, please let me know if I am doing something wrong:

For CF Administrator:

enter image description here

For SQL Server Management Studio

enter image description here

Data Source:

enter image description here

John
  • 145
  • 8

1 Answers1

5

The error message clearly says, that the error is due to Authentication failure. You need to enable Mixed-mode authentication. Once enabled, try to login and check the error message, if fails again. Try restarting SQL Server/Agent service with windows authentication credentials, to validate that there is no problem.

Alternatively, try skipping the username/password in CF Admin and connect. You may then specify them at the query level as well.

Anit Kumar
  • 368
  • 1
  • 10