System information
45
CONFIGURING AND ADMINISTERING COLDFUSION 9
Data Source Management
Last updated 2/21/2012
Settings for the Northwind sample database
Previous versions of SQL Server included a sample database named Northwind. Establishing a connection to the
Northwind database can help you learn ColdFusion while using a familiar database.
To establish a connection to the SQL Server Northwind database, set up the database in the SQL Server Enterprise
manager and in the ColdFusion Administrator.
Set up the database in the SQL Server Enterprise manager
1 Expand the server group.
2 Expand the server.
3 Under the Security folder, right-click on Logins.
4 Select New Login.
5 Select Windows Authentication or SQL Server Authentication settings.
6 Select the Northwind database, and specify the language.
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.
BLOB Buffer The default buffer size, used if the BLOB option is not selected. The default value is 64000 bytes.
Allowed SQL The SQL operations that can interact with the current data source.
Validation query Called when a connection from the pool is resued. This can slow query response time because an additional query
is generated. Configure the validation query just before restarting the database to verify all connections, but
remove the validation query after restarting the database to avoid any performance loss.
Setting Description