• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

Problem with connecting to a SQL Server 200 on W2k3

Hi,

I have a serious problem with ColdFusion and Windows 2003 Server.

I have defined some datasources with correct username & password. But I get this error message:

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

Can someone help me?
0
Michael_O
Asked:
Michael_O
1 Solution
 
sandy12879Commented:
Hi

Just try this

Enter SQL Enterprise Manager.

Find your server name in the tree on the left.

Right mouse click on the server name and select properties.

Click the Security folder.  You should now see the screen below with "Windows Only" set as the default authentication.

Check SQL Server and Windows as the Authentication

Click OK.

Click Yes to restart SQL


Let me know

Regards

Sandy
0
 
Michael_OAuthor Commented:
Yes, It has solved the problem. But I have such problem on another computer running windows XP.

Is there any other reason for this problem ?

Regards,

Michael
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now