Connect to network data sources

If you have Windows NT machines set up as standalone servers rather than as members of a domain, accessing a remote data source on one of the standalone servers from a standalone ColdFusion machine directly requires the following steps:

  1. Create a Windows NT domain user account named ColdFusion. Set the username to cfusion and assign a password, such as pword. Assign the least administrative privileges to the account.

  2. Create an account call ColdFusion on the remote standalone machine. Set the username to cfusion and the password to pword. The usernames and passwords on both machines must match. Assign this account full privileges on the shared directory where the database resides.

  3. Log off the Windows NT machine and log onto the domain as username cfusion and password pword.

  4. Stop the ColdFusion service.

  5. Open Windows NT Explorer and select Tools>Map Network Drive.

  6. In the Drive box, select None.

  7. In the Path box, select the mapped drive where the database resides. If it does not appear, enter \\yourmachine\yourshareddirectory and click OK.

  8. Start the ColdFusion service logging on as yourdomainname\cfusion with the password pword.

  9. Stope and restart the ColdFusion service so the changes take effect. The ColdFusion service no runs under the cfusion account.

  10. In the ColdFusion Administrator, set up an ODBC data source pointing  to that remote database.

  11. Verify the connection.

  12. Check whether you can connect to the data sources with MSQuery, the Microsoft tool that uses ODBC the same way as does ColdFusion.

 

With these settings, you can verify that your permissions are sufficient to access the remote data source.

Related topics