Skip to main content
U
unixsyadm
Known Participant
October 30, 2006
Question

creating a datasource to connect MS SQL server

  • October 30, 2006
  • 1 reply
  • 671 views
I am using CF 7 and trying to create a datasurce to connect to my MS SQL server database.

I get the following error when trying to create a Datasource:

I have tried using the MS SQL server driver and also using Other

I continue to get the error:

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'trubel'. Reason: 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 'trubel'. Reason: Not associated with a trusted SQL Server connection.

Can anyone help me?

Tim Rubel
AIM: unixsyadm

This topic has been closed for replies.

1 reply

T
tzimmerman
Participating Frequently
October 31, 2006
Make sure your database uses mixed authentication, both SQL Server and Windows.

Ted Zimmerman
U
unixsyadmAuthor
Known Participant
November 1, 2006
Can you point me to documentation that would show me how to make sure mixed authentication is setup?
I have checked the security login feature in the Enterprise Manager and the user ID and password I am providing exists in the SQL server.
T
tzimmerman
Participating Frequently
November 1, 2006
To set up Windows Authentication Mode security with Enterprise Manager in SQL Server:

Expand a server group.
Right-click a server, and then click Properties.
On the Security tab, under Authentication, click Windows and SQL Server Authentication.

See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_6p9v.asp

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