Studio uses the Database Connection Manager in the ColdFusion Server to connect to remote data sources.
To add an RDS server for database access:
Click the Remote Files tab.
Right-click in the file list and select Add RDS Server.
Complete the Remote Host fields in the Configure RDS Server dialog:
Description -- Required. The name that appears in the server list.
Host Name -- Required. The server domain name, such as www.allaire.com or an IP address.
User Name -- Required if the server is password-protected. Open the ColdFusion Administrator Server page to edit the Studio password.
Password -- Optional. If the server is password-protected you must use a password. Open the ColdFusion Administrator Server page to edit the Studio password.
Port -- Required. The port on the server used by the Web server. Use default unless specified by server administrator.
Use Secure Sockets Layer (SSL) -- Optional. Allows exchanges between Studio and the server to be encrypted via SSL.
Complete the ColdFusion RDS Security fields:
User Name -- Required if the server is password-protected. Open the ColdFusion Administrator Server page to edit or disable the Studio password.
Password -- Optional. If the server is password-protected you must use a password. Open the ColdFusion Administrator Server page to edit or disable the Studio password.
Click Prompt for Password to enable these entries.