Re: not associated with a trusted SQL Server connection? please h elp

[cf coder]

No, I don't want my web application to work that way. I check the LDAP directory if the user is a member of a group, if yes then he is directed to the web home page.

Something that I forgot to mention in my earlier post was that, the ColdFusion server and SQL server are running on two different boxes.

Recap:
What you already know is that the SQL server authentication is set to 'Windows only' because of the reasons I mentioned in my earlier post. Since CF does not currently support trusted connections, validating a datasource connection fails.

I've written a simple script to pull data from the sql server using the cfquery tag

<cfquery name="getDetails" datasource="db_live" username="domain\username" password=")*$%***$$)$">
    select *
    FROM employee
    WHERE empNumber = '01DS065338'
</cfquery>

<cfdump var="#getDetails#">

As you would expect I get this error message:

[Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user &apos;domain\username&apos;. Reason: Not associated with a trusted SQL Server connection

When you say I will need to enable the native sql logins, do you mean "iuser" logins? There are a couple of iuser logins that already present on the server

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---