81
CONFIGURING AND ADMINISTERING COLDFUSION 10
Data Source Management
L
ast
u
p
dated
7/9/2
01
2
7
Ensure that the database server is using mixed authentication. While in Enterprise Manager, right-click the server,
select Properties > Security and then select the Security tab. Ensure that the SQL Server and Windows options are
clicked.
8
Click OK.
Set up the database in the ColdFusion Administrator
1
Open the ColdFusion Administrator.
2
Click Data & Services > Data Sources.
3
Type
northwind
in the Data Source Name field, and select Microsoft SQL Server in the Driver drop-down list.
4
Click Add.
5
Type
Northwind
in the Database Name field,
127.0.0.1
(or the database server IP address) in the Server field, and
1433
in the Port field.
Note:
Do not specify a user name or password when defining the data source.
6
Save the data source.
Troubleshooting SQL Server connections
If you are having trouble establishing a connection to SQL Server, review the following considerations:
•
If you installed SQL Server using a server name other than the default, use your chosen domain\servername
wherever there’s a reference to (local).
The following situations can cause a Connection Refused error:
•
If you specified authentication information in SQL Server, ensure that you have not defined a user name and
password in the ColdFusion data source.
•
You are running a connection-limited version of SQL Server and the request exceeds the limit for TCP/IP
connections.
You can prevent this exception by setting the Limit Connections and Restrict Connections To options in
ColdFusion Administrator on the Advanced Settings page for the data sources, and specifying a number less than
the SQL Server maximum.
•
SQL Server does not enable the TCP/IP protocol. This problem can happen when SQL Server is on the same
computer as ColdFusion. To fix this problem, perform the following steps:
1
In SQL Server Enterprise Manager, right-click on the name of your SQL Server and click Properties.
2
Click Network Configuration and the General Tab.
3
Move TCP/IP from the Disabled Protocols section to the Enabled Protocols section.
4
Click OK.
5
Restart the SQL Server services.
6
Verify your data source.
•
If you have are having trouble connecting, consider using mixed-mode authentication for SQL Server (Windows
and SQL) and removing the user name and password from the ColdFusion data source.