如何配置ColdFusion 8数据源以连接到本地SQL Server 2008服务器？ [英] How do you configure a ColdFusion 8 datasource to connect to a local SQL Server 2008 server?

问题描述

我已经设置了本地SQL 2008 Server，启用了SQL身份验证，为ColdFusion创建了一个要使用的用户，并验证了可以使用SSMS使用该用户名和密码进行连接。 （使用MACHINENAME\SQLEXPRESS连接）

I've set up a local SQL 2008 Server, enabled SQL Authentication, created a user for ColdFusion to use and verified that I can connect with that username and password using SSMS. (Connect using MACHINENAME\SQLEXPRESS)

但是，我无法在CF Administrator中成功添加数据源，错误是：建立到主机和端口的套接字时出错

However, I am unable to successfuly add the datasource in my CF Administrator, with the error being: Error establishing socket to host and port

是否需要连接服务器或ColdFusion的其他配置？

Is there additional configuration of the server or ColdFusion that is necessary to connect?

推荐答案

您应该只可以使用LOCALHOST作为服务器名称，并使用端口1433作为端口号。您可能必须通过SQL Server配置管理器启用IP连接。您可以在Google上搜索有关如何执行此操作的说明，我在此处找到和此处。

You should be able to just use LOCALHOST as the server name, and port 1433 as the port number. You may have to enable IP connections through the SQL Server Configuration Manager. You can search Google for instructions on how to do that, which I found here and here.

这篇关于如何配置ColdFusion 8数据源以连接到本地SQL Server 2008服务器？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！