Skip to main content
C
coder1957**
Known Participant
July 10, 2010
Question

CFMX7 vs. SQL 2000 on Win 7 Ultimate

  • July 10, 2010
  • 1 reply
  • 1474 views

Been using CF since ver 1 and never had db issues before.

Installing CFMX7 (temporarily) on a MacBook PRO running Bootcamp,

Succesfully installed SQL personal Edition. 2000. Pack 4.

Also CFMX7 installed fine.

Attached a known good and visible DB into SQL.

But when I add it as a data source it will not connect to CF.

I read in MS notes about needing Windws Authentication permission only perhaps.

But in the properties screen in CF I have always needed to supply a DB sys account name and password.

I have one in there but it simply will not take .... how do I make this work without

- getting SQL2005? 

Many thanks.

Robert

This topic has been closed for replies.

1 reply

J
JR__Bob__Dobbs
Inspiring
July 12, 2010

Questions/Things to Check:

1. Does your SQL 2000 install support SQL authentication?

2. Is TCP/IP communication enabled for SQL server?
    http://support.microsoft.com/kb/827422
    http://support.microsoft.com/kb/841252

3. Is the port that CF communicates with SQL open, not blocked by a firewall?
    http://support.microsoft.com/kb/287932

4. What does "a known good and visible DB" mean?  Visible where?

C
coder1957**Author
Known Participant
July 12, 2010

It's simpler ... I am using it locally only ...

Local CF, local SQL.

I told SQL 2000 when installing it on this spare laptop to support local auth, yes.

Yet in security it also has a login.

Good and visible ... I mean I succesfully attached a known db to the local "list" ... and it took and is visible from within Enterprise Manager.

Since then I really ... well, went in another direction ... figured it was time to upgrade so downloaded and install the eval for SQL 2008 R2.  3 hours later ... oh no ... I was NOT looking for a LEARNING CURVE ... so now wondering if I should down grade again or press on and learn SQL 2008 and see if IT even succesfully is read by CF!

As for firewall, GOOD Q.  I don't know ... brand new refurbished test laptop. Looking fo firewall!

J
JR__Bob__Dobbs
Inspiring
July 12, 2010

Can you successfully use a SQL login (not a Windows account) to login to SQL Server using Query Analyzer?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices