?
Solved

Can't Connect to SQL Server

Posted on 2005-03-24
5
Medium Priority
?
190 Views
Last Modified: 2013-12-16
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?
0
Comment
Question by:JRockFL
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 1

Expert Comment

by:rffallon
ID: 13628073
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*
0
 
LVL 8

Author Comment

by:JRockFL
ID: 13629544
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.
0
 
LVL 7

Expert Comment

by:jay_eire
ID: 13631020
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
(<>..<>)
0
 
LVL 1

Accepted Solution

by:
rffallon earned 2000 total points
ID: 13631040
Make sure that you enter your 'RDS Password' for you CF Server.
Then select the data source type and the connection string.
0
 
LVL 8

Author Comment

by:JRockFL
ID: 13631049
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
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question