- 1). Open the ColdFusion Administrator website in a browser. If you are logged in to the computer hosting ColdFusion, you can find a link in the programs menu. If not, navigate to the server address, followed by "\cfide\administrator" to open this page.
- 2). Click "Data & Services" in the left menu bar, followed by "Data Sources."
- 3). Enter a name for the data sources in the section labeled "Add New Data Source." You cannot use the following reserved words: "service", "Jms_provider", "comp", or "jms", as data source names.
- 4). Select the driver to use from the drop-down list. The driver should be specific to your database manufacturer and version. Click "Add" after selecting the driver.
- 5). Enter the name of the database in the "Database" field. Provide the server address in the "Server" field. The server field can use a network URL or the IP address and supports changing the port if needed.
- 6). Enter the user name and password to connect to your database if your database requires them.
- 7). Complete the optional fields of description and advanced settings if you want to. Configuring advanced settings allows you to limit supported SQL commands.
- 8). Click "Submit" to create the data source and verify that it works properly. You will be returned to the main data source page; the data source will show "OK" next to it if the connection was successful.
Source...