Copy link to clipboard
Copied
I am trying to set up a DSN to a SQL Server database, but keep getting an error. SQL Server Browser IS running.
I think I just may have solved it. I ran the SQL Server Configuration Manager, and made sure that TCP/IP was inabled, and I think that did it. Weird, right? Does that even make sense to you? Thanks!
Copy link to clipboard
Copied
Can you please let us know the version of Coldfusion you are using? Also, let me know if you have installed the SQL server on a different machine. If so, can you telnet to the DB host and port from the server where Coldfusion is installed?
Copy link to clipboard
Copied
I think I just may have solved it. I ran the SQL Server Configuration Manager, and made sure that TCP/IP was inabled, and I think that did it. Weird, right? Does that even make sense to you? Thanks!
Copy link to clipboard
Copied
Yes, this is required for SQL Server connections from ColdFusion.
Dave Watts, Eidolon LLC
Copy link to clipboard
Copied
Thanks. That seems to have fixed it. 🙂