I went through something similar with SQL 6.5 only I could not get the CF
admin to verify my ODBC datasource either. The deal in my situation was all
about permissions, we had to choose weather we were going to assign
permissions on the DB or on the web server (different than your situation I
know), and it all boiled down to how does the database interpret the users
permission. What we finally did was to log the cf service on as a user with
permission to use that database, but we could have just as easily set up all
the users and their permissions in the database. I don't know if in your
situation weather changing the Cold Fusion RDS service login account from
system to a particular user will solve your problem or not, just thought I
would share my experience in hopes it will give some idea's
Good Luck
----- Original Message -----
From: "Dave Gammage" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 10, 2001 3:55 PM
Subject: [KCFusion] SQL Server 2000 login issues
> Hey all...
>
> I've just configured a SQL 2000 test server, and I'm having difficulty
> logging into it through RDS. I've set up the datasource on the CF server,
> both in CF Admin and ODBC, and the datasource verifies correctly. However,
> using the same credentials while accessing through RDS in Studio, I get an
> authentication failed notification after I enter the username/pw. This is
> the first SQL server I've had, so am I just missing something blatantly
> obvious?
> Thanks!
> --
> >>>>>>>>>>>>>>>>>>>>>>>>>
> Dave Gammage
> Digital Prairie
> www.digital-prairie.com
> Er versuchte mit heiler Haut davonzukommen
>
>
>
>
> ______________________________________________________________________
> The KCFusion.org list and website is hosted by Humankind Systems, Inc.
> List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
> Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
> To Subscribe.................... mailto:[EMAIL PROTECTED]
> To Unsubscribe................ mailto:[EMAIL PROTECTED]
>
>
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
