Results 1 to 2 of 2

Thread: Login Failed

  1. #1
    Join Date
    Feb 2002
    Location
    India but now in KSA
    Posts
    1

    Wink Unanswered: Login Failed

    When i am connecting to MSQL server my application it raising this error instead of connecting.
    login failed for user 'sa' Reason associated with a trusted SQL Server connection.

    Anybody can help me regarding above error.

    Thanx in Advance.
    SAB

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Is the message really
    login failed for user 'sa' Reason NOT associated with a trusted SQL Server connection.

    It will be because you have set your connection up to use nt security but trying to connect with a username and password.

    Decide if you want to use sql server or NT security
    If sql server
    Make sure that the server allows mixed security
    Make sure the connection allows it (connection string, odbc datasource...)

    If NT security then don't pass sa as the user name.
    (It's a very very bad idea to use sa as an application user).

Posting Permissions

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