SQL Server driver Problem

[dwright65]

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

[Newsgroup_User]

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

[JR__Bob__Dobbs-qSBHQ2 · Accepted solution]

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).

[Newsgroup_User]

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.