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

Connecting to SQL Server 2000

I have tried to connec tto my SQL database both from a client machine and through an ODBC connection on the server itself.

The ODBC connection gives the following error message

SQL State 28000 SQLServer Error 18452 ODBC SQL Server Driver - Login Failed for 'sa' - Not associated with a trusted connection.

Through the program on the client machine I get the error, Login failed for Demon - Not associated with a trusted connection
1 Solution
Dear rocky050371

Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

check the below links for more details

Try to connect using Query Analyzer with the same username/password and see what happens.

Also, the client machine should have the client connectivity tools.
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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