System information

46
CONFIGURING AND ADMINISTERING COLDFUSION 9
Data Source Management
Last updated 2/21/2012
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.
Connecting to MySQL
To see a list of MySQL versions that ColdFusion supports, go to www.adobe.com/go/learn_cfu_cfsysreqs_en.
Note: By default, queries to MySQL data sources return isCaseSensitive = NO for each column in the return structure
from the
GetMetaData function. Set the system property -Dcoldfusion.mysql.enableiscasesensitive=true to
turn on the calls to isCaseSensitive.
Use the settings in the following table to connect ColdFusion to MySQL data sources:
Setting Description
CF Data Source Name The data source name (DSN) that ColdFusion uses to connect to the data source.
Database The database to which this data source connects.
Server The name of the server that hosts the database that you want to use. If the database is local, enclose
the word local in parentheses.
Port The number of the TCP/IP port that the server monitors for connections.
User name The user name that ColdFusion passes to the JDBC driver to connect to the data source, if a ColdFusion
application does not supply a user name (for example, in a
cfquery tag).