Hi

We only recently started offering Cold Fusion MX services to our customers and ran into a problem. We have separate web servers and database servers. On the web servers we have Cold Fusion MX enterprise deployed. On the database servers, SQL Server 2000.

When a customer wants to store his data in an MS Access database, that is no problem, we simply create a CF DSN for that customer as the database is located on the same web server. But when the customer wants to use a SQL Server database, the database is hosted on a totally different server. We haven't been able to create a DSN for a SQL Server database on a different server. Anyone here knows how to this? Is there some other way customers can connect to these SQL Server databases?

When you go to create the DSN does it not have these fields:

CF Data Source Name
Database
Server Port

Username

Password
Description

CFMX should have those fields available, and if it does it is a breeze to set up, it the server is local you can put in 127.0.0.1 or localhost, or if the server is remote you can enter the IP or the hostname.

Coldfusion is tons of fun eh?

I'm assuming that your coldfusion server is on a Windows box. Most of my experience is with Unix and cf on unix but I believe this is how you do it.

First, you need to make sure that you have that DSN declared on that webserver. Not in coldfusion, but in windows. Once that is in your DSN list for the webserver, then you should be able to add it as DSN in your coldfusion admin.

Being that i'm no pro at windows, i'm also going to state the obvious. Make sure you have the drivers installed on this machine so it can talk to your SQL Server.

-Jason

With CF MX I have not had to create a DSN in windows first, in fact, it does not good because you just have to create it again in the cfmx admin.

somehost,

I imagine amd_duron answered your question, but here are some links that may help:

http://livedocs.macromedia.com/coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

http://www.macromedia.com/support/coldfusion/ts/documents/tn18245.htm

http://livedocs.macromedia.com/coldfusion/5.0/Installing_and_Configuring_ColdFusion_Server/datasources7.htm