Hello Guys:
I'm running Windows 2000 on my local machine and using IIS (as a web server) for a project that I will be working on. I have also installed ColdFusion 5 Studio as well as CF Server on my machine. The SQL Server database that I will be using is located on another machine/server which is in the same domain as my local machine. With a help of a member here, I have set up my ODBC (System DSN) settings to point to the database server and successfully tested the data source. I can see the data source name on the CF Administrator ODBC Data Sources page but I get the following error message when I try to verify the connection. Could someone please give me some idea on how to fix this?????
The error message is as follows:
The connection to the data source failed. Check the following to resolve this problem:
Are the data source settings configured properly?
Did you provide valid security information in the data source settings ?
For some databases the ColdFusion Server may need to be logged in under a special NT account rather than the default System Account. Use the Windows NT Services Control Panel to change the account the ColdFusion Server service is using.
Thanks in advance!!!!
I'm running Windows 2000 on my local machine and using IIS (as a web server) for a project that I will be working on. I have also installed ColdFusion 5 Studio as well as CF Server on my machine. The SQL Server database that I will be using is located on another machine/server which is in the same domain as my local machine. With a help of a member here, I have set up my ODBC (System DSN) settings to point to the database server and successfully tested the data source. I can see the data source name on the CF Administrator ODBC Data Sources page but I get the following error message when I try to verify the connection. Could someone please give me some idea on how to fix this?????
The error message is as follows:
The connection to the data source failed. Check the following to resolve this problem:
Are the data source settings configured properly?
Did you provide valid security information in the data source settings ?
For some databases the ColdFusion Server may need to be logged in under a special NT account rather than the default System Account. Use the Windows NT Services Control Panel to change the account the ColdFusion Server service is using.
Thanks in advance!!!!