Skip to main content
S
seattlebears
Participant
May 2, 2007
Answered

Coldfusion connection to MS SQL 2005

  • May 2, 2007
  • 1 reply
  • 563 views
Please help with this issue if you have any suggestions. I am trying to establish a connection from my IIS server with ColdFusion to another local server with an MS SQL 9.0 database. I can connect to this database using Enterprise from another computer, but when I use the same username and password within ColdFusion I get the following error:

Connection verification failed for data source: FORMS
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'domain\coldfusion'. The user is not associated with a trusted SQL Server connection.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'domain\coldfusion'. The user is not associated with a trusted SQL Server connection.

I have reinstalled ColdFusion with no errors and have also installed the MS JDBC driver for MS SQL 2005 but still get the same error.

Thanks for any suggestions you might have.

Craig
This topic has been closed for replies.
Correct answer seattlebears
If there is anyone else with this problem I have something that you may want to try. This did work for me and I'm able to connect to SQL 2005 using ODBC Socket. The IIS computer was using system credentials and not the ColdFusion credentials I had created.

On the ColdFusion application server goto the Properties of CF's ODBC server and agent. Under LogOn change the LogOn information to the username and password you have set up for ColdFusion for both and restart these services. When setting up your ODBC Socket do not include username or password information.

Hopefully CF8 will include Windows Authentication. Even with this workaround we may need to switch to mixed authentication on SQL which is not ideal.

1 reply

S
seattlebearsAuthorCorrect answer
Participant
May 2, 2007
If there is anyone else with this problem I have something that you may want to try. This did work for me and I'm able to connect to SQL 2005 using ODBC Socket. The IIS computer was using system credentials and not the ColdFusion credentials I had created.

On the ColdFusion application server goto the Properties of CF's ODBC server and agent. Under LogOn change the LogOn information to the username and password you have set up for ColdFusion for both and restart these services. When setting up your ODBC Socket do not include username or password information.

Hopefully CF8 will include Windows Authentication. Even with this workaround we may need to switch to mixed authentication on SQL which is not ideal.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices