asked on

Can't Connect to SQL Server

I have 2 computers, a server and workstation. Server has SQL Server 2000, CFMX 6.1. The workstation has DWMX 2004

I'm trying to setup a SQL Server connection, but when I click "test" or "ok" it doesnt do anything, like it doesnt even try to connect.

I can see all the files fine on the server. I have EM manager on my workstation, I can open that up fine and see the dbs.
If I click "set up coldfusion datasource" it opens up the ColdFusion Admin login page just fine.

What can I do?

rffallon

you might have to setup you data source in the CF administrator http://localhost/CFIDE/administrator then access it through DW.

if you are using ASP VB then a DSN-less connection would be *Provider=SQLOLEDB;Server=YOURSERVER;Database=YOURDB;UID=USER;PWD=PASSWORD*

JRockFL

ASKER

I am using ColdFusion. Yes, I already have the datasource set up and it works fine.

The problem is when I try to "register" the db in dreamweaver.

jay_eire

Hi JRockFL,
there is a good tech note on Troubleshooting data sources and database connectivity for Windows platforms using Macromedia ColdFusion.

http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17115

Thanks
Jay Eire
(<>..<>)

ASKER CERTIFIED SOLUTION

rffallon

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

JRockFL

ASKER

It was the RDS password, either I did not enable RDS on the CF Install, or I was using the wrong password.

I unistalled CF, reinstalled it, enabled RDS and used the password and it works.

Thank you