Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    6

    Unanswered: "Login failed for user" error

    Hi

    I have installed sql server on my standalone PC.

    I used "window and sql mix authentication" for the sql server in the enterprise manager set up.
    when I try to use the sql server login name for the startup service account, I have this error. "No Mapping between names and security IDs ".
    So Even though I use mix authentication, I am still using window login name.

    Then I create the DSN file.


    But when I run the ASP program, I have this error "login fail for user-("user name that I used for dsn file configuration").

    I try to configure the dsn file set up with both authentications, windows and sql login names.

    But I got the error again.

    I am really lost here.
    Please help me. thanks...

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    What's your connection string?
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    Quote Originally Posted by nov
    when I try to use the sql server login name for the startup service account, I have this error. "No Mapping between names and security IDs ".
    You cannot use a sql server login for the service accounts, these need to be windows accounts (domain or local user, or system account). The mixed authentication only applies to logins to the server.
    Johan

Posting Permissions

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