connecting to remote SQL Server

[quest007]

Hi!
This might be a very simple query for all those working on Coldfusion but difficult for novice like me.
I have to fetch data from the SQL Server database which is on a remote server.
Can someone help me with the code that I need to write in the <CFQUERY> tag. I have written the code as:

<cfquery name="qry_fetch_user" datasource="234.208.90.15" dbname="myDatabaseName"  >

If I execute this, it displays the error:

CFML Runtime Error - > General Runtime Error - > "The datasource 234.208.90.15 could not be found or was invalid"

I am not using Coldfusion server but another software which allows integration of ASP.Net and Coldfusion i.e. Bluedragon(from BEA Weblogic).
Thanks in advance.

[acoder]

The datasource is defined in the Coldfusion Administrator. As far as I'm aware it has to be on the local server. How about you write some code on the remote server that accesses this database and then access that page?

[quest007]

Thanks for the help. I could connect to the datasource after the I did the following:
- using a DSN
- setting some security related attibutes viz., "Annoymous Access" and "Integrated Windows Authentication" in the properties of the Virtual Directory for the website in IIS.
- setting the permissions for "ASPNET" user on the database.

This made the things work !

[acoder]

Thanks for the help. I could connect to the datasource after the I did the following:
- using a DSN
- setting some security related attibutes viz., "Annoymous Access" and "Integrated Windows Authentication" in the properties of the Virtual Directory for the website in IIS.
- setting the permissions for "ASPNET" user on the database.

This made the things work !

Oh right, it was a permissions/security issue. Well done!