Results 1 to 6 of 6

Thread: Login failed

  1. #1
    Join Date
    Oct 2006
    Posts
    7

    Unanswered: Login failed

    login failed for user 'sa'. Reason: Not associated with a trusted SQL Server Connection

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    What's your point?
    George
    Home | Blog

  3. #3
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    well would you be more precise in explaining how you got that and what issue you want to resolve ?????

  4. #4
    Join Date
    Oct 2006
    Posts
    7

    Re:

    Quote Originally Posted by nick.ncs
    well would you be more precise in explaining how you got that and what issue you want to resolve ?????

    I Got error when tried to login in Query Analyzer.

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Are you connecting using windows authentication or SQL server authentication (enter username & password)? We can assume but it's best if you provide us with all the facts
    George
    Home | Blog

  6. #6
    Join Date
    May 2007
    Posts
    23

    Change Authentication Properties

    Hi
    Change your authentication properties to MIXED MODE.

    Generally you get this type of message when you instal SQL server with windows mode authentication

    Hope this will help and solve your problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •