'Creating datasource in CF2011 using SQL Server windows Authentication
I just downloaded the free Coldfusion 2011 developer version and also SQL Server 2019 developer version both to my laptop. My Laptop is running windows 10. I tested my CF 2011 is working and also my MSSMS is working, created a test database, tables.
When launching MSSMS I think by default the Connect to Server Windows is set to Windows Authentication. All I need is to click the connect button and I'm connected to the SQL SERVER. Now that I need to create a datasource from my CF administrator I have an issue.
After I fill in the CF Datasource name, Server name, Database name and the default port 1433 error show up in red after I clicked the submit button:
Connection verification failed for data source: TestDB java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: MYOWNPC:1433. Reason: Connection refused: connect
Do I have to uninstall SQL server and re-install it as I wasn't sure if I have to provide a username and password in the begining of installation. Maybe that's the reason Microsoft by default chose Windows Authentication for me? What do I need in order for me to be able to create the datasource, thank you
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|