verification failed for datasource-not trusted SQLServer conne

[cfdeveloper]

sub: Connection verification failed for data source: "DSNNAME" Reason: Not associated with a trusted SQL Server connection.


The SQL server we have running sits on its own box. So, the web server is independent of it. There are ODBC connections from the web server to the SQL server. The sql server authentication is set to 'Windows only'. I was reading somewhere that ColdFusion MX does not yet support t
rusted connections while using the available JDBC drivers and cannot connect to databases requiring trusted connections. To permit CFMX to connect to the database using the SQL Server JDBC driver, one is supposed to configure the database authenication to permit "SQL Server and Windows". I'm told by the network guys that I'm not suppose to change this. What options am I left with? I'll apprecaite your help

Best regards,
cfcoder

 

[TruthInSatire]

I heard this from someone who heard it from someone who heard it from someone so if it's a little off i'm sorry. the cfadministrator has to have a username in the services area, then the sql server box has to allow that user to connect. I know its vague and my not even be 100% correct. hope it sends you in the right direction.

Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)

 

[cfdeveloper]

we are using a desktop application/product (third party) that connects
to the sql server with integrated windows authentication. When you lau
nch the application window, it authenticates the user against the wind
ows login.

I am working on a project that replaces this desktop client applicatio
n with a web frontend application. The desktop application is configur
ed to only work if the sql server authentication is set to 'Windows on
ly'. Both the applications are meant to connect to the same sql server.
Because of the way the sql server is configured (ie windows only authe
ntication), I can't get ColdFusion to validate the datasource name wit
h a windows login username.

Is it possible to get a cfquery tag to pull data from a sql server (wi
th the above configuration) without specifiying the "datasource" attri
bute? I've noticed that cfquery has the following attributes:

dbserver
dbname
username
password

I'll really appreciate your help

Best regards,
cfcoder

 

[cfdeveloper]

we are using a desktop application/product (third party) that connects to the sql server with integrated windows authentication. When you launch the application window, it authenticates the user against the windows login.

I am working on a project that replaces this desktop client application with a web frontend application. The desktop application is configured to only work if the sql server authentication is set to 'Windows only'. Both the applications are meant to connect to the same sql server.
Because of the way the sql server is configured (ie windows only authentication), I can't get ColdFusion to validate the datasource name with a windows login username.

Is it possible to get a cfquery tag to pull data from a sql server (with the above configuration) without specifiying the "datasource" attribute? I've noticed that cfquery has the following attributes:

dbserver
dbname
username
password

I'll really appreciate your help

Best regards,
cfcoder

 

[ecobb]

Just out of curiousity, how are you entering the login in the datasource connection? If you're trying to use windows authentication, you'll need to specify "domain/username" instead of "username" in your connection. You may have already tried this, I just thought I would throw it out there.



Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

 

[cfdeveloper]

I already that, but I still get the "Not associated with a trusted SQL Server connection". Here is the code:

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

<cfdump var="#getDetails#">

I posted this same thread on the macromedia forums and got this reply.

http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=3&threadid=862163

Has anyone installed DatDirect 3.3? If so have you had any problems with it?

Cheers,
cfdoder

 

[cfdeveloper]

thank you all for your help on this. I've got it to work, but it wasn't straightforward. I tried every single trick from the book, but just couldn't get it to work.

I got a reply from someone on the coldfusion macromedia forums yesterday and he asked me to refer to this url:

http://www.macromedia.com/support/coldfusion/ts/documents/tn18245.htm

I thought I'll share my experience with you all.. I'm sure a few people out there would be interested in hearing what I captured so here it goes.

Step 1: I configured an ODBC data source using the ODBC Driver Manager on the pc/server where ColdFusion is installed. In the ODBC Deriver Manager, I selected the sql server from the drop-down (Note: The SQL server we have running sits on its own box). I then clicked on 'Next' and tick the "with Windows NT authentication using the Network ID" radio button for the "how should sql server verify the authenticty of the login ID" section. On the last step I clicked on the "Test Data Source" button and it came back with "TESTS COMPLETED SUCCESSFULLY!".

No problems at all.

Step 2: In ColdFusion Administrator, I created a new datasource with "ODBC Socket" driver option selected. I selected the ODBC DSN creted in the previous step, ticked the "Trusted Connection" checkbox, left the username and password fields blank and clicked "Submit."

I got the following error message,

Connection verification failed for data source: DB_PRODUCTION
[]java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'REGIONAL\SATURN6$'.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'REGIONAL\SATURN6$'.

'REGIONAL\SATURN6$' is the machine account on the box where coldfusion is installed. I gave this account permission to access the database on the sql server and wholla, it worked.

Hope this helps

Thanks again
cfcoder