Note that if it's still "not working" after you make these changes, do make sure you don't see a different error, like "Cannot open database "yourdbname" requested by the login. Then restart SQL Server and verify the DSN again. If you don't want to enable the "ipall" option, check the other entries to find the IP you're using (which may be 127.0.0.1 or ::1, if using "localhost" for the "server" you're telling CF to connect to), and ensure both that it's "enabled" and that its "tcp port" option is set to 1433. (In later versions, where you don't readily find that Configuration Manager, see my discussion below under "The solution" for other ways to get to that feature.)Īnd if it is enabled, right-click on that TCP/IP option, choose "properties", then its "IP Addresses" tab, and among the listed features, check if "ipall" (among the last in the list) has the port set to 1433 (or whatever is your SQL Server port), then restart SQL Server. ![]() For the official MS docs on this, see it discussed in this related topic. If not, enable it, and restart SQL Server. Open it and ensure that TCP/IP is enabled as a protocol. Open the "SQL Server Configuration Manager" in SQL Server, then choose "SQL Server Network Configuration", and its "Protocols For " option. And I may revise the content as necessary.Īre you getting the error, "Connection refused" or "Error establishing socket to host and port", trying to connect to a SQL Server database from ColdFusion? Corrections are welcome, in the comments. Same with links and subsequent comments from myself or others. Some content may be outdated-though not necessarily.
0 Comments
Leave a Reply. |