Skip to main content
D
dwright65
Known Participant
November 12, 2008
Answered

SQL Server driver Problem

  • November 12, 2008
  • 3 replies
  • 654 views
I just got a new computer and had to reload all of my software including SQL Server and Cold Fusion. I've got everything set up now, but for some reason, I can't get Cold Fusion to access the database at all. I get the message "Login failed for user 'dwright'. Reason: Not associated with a trusted SQL Server connection." The ID exists and is set up with the appropriate privileges.

Anyone know why I'm getting this error?

Thanks

DW
This topic has been closed for replies.
Correct answer JR__Bob__Dobbs-qSBHQ2
Verify that your SQL Server allows Mixed mode authentication. This is disabled by default in SQL 2005 (and possibly 2008, if I'm wrong someone please correct me).

3 replies

N
Newsgroup_User
Inspiring
November 12, 2008
JR Bob Dobbs wrote:
> Verify that your SQL Server allows Mixed mode authentication. This is disabled by default in SQL 2005 (and possibly 2008, if I'm wrong someone please correct me).
>
>

That is what I have read many times. :-) I just could not recall the
correct terminology.

J
JR__Bob__Dobbs-qSBHQ2Correct answer
Inspiring
November 12, 2008
Verify that your SQL Server allows Mixed mode authentication. This is disabled by default in SQL 2005 (and possibly 2008, if I'm wrong someone please correct me).

N
Newsgroup_User
Inspiring
November 12, 2008
I am not an expert on this and can only offer some very vague advice.

I have read many times that the default configuration of SQL server does
not enable the type of connection required by ColdFusion. Something
about named pipes or something like that.

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