Can't create DSN — java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]

[ssailer]

I am trying to set up a DSN to a SQL Server database, but keep getting an error.  SQL Server Browser IS running.  

• Connection verification failed for data source: mvqs
  java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The connection to the host {0}, named instance {1} has failed. Error: "{2}". Verify the server and instance names, check that no firewall is blocking UDP traffic to port 1434, and for SQL Server 2005 or later verify that the SQL Server Browser Service is running on the host.
  The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The connection to the host {0}, named instance {1} has failed. Error: "{2}". Verify the server and instance names, check that no firewall is blocking UDP traffic to port 1434, and for SQL Server 2005 or later verify that the SQL Server Browser Service is running on the host.

[RaviShankar Chagnur]

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?

[ssailer · Accepted solution]

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!  

[Dave Watts]

Yes, this is required for SQL Server connections from ColdFusion.

Dave Watts, Eidolon LLC 

[ssailer]

Thanks.  That seems to have fixed it.  🙂