Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Posts
    8

    Unhappy Unanswered: MSDE 2000 and ODBC (Connection failed)

    Hi
    I Installed MSDE 2000 and try to connect with it via ODBC.
    I want the connection with SQL Server authentication using a login ID "sa" and blank password
    But it is dispaly this message:
    ====================
    Connection failed:
    SQLState:'28000'
    SQL Server Error:18456
    [Microsoft][ODBC Sql Server Driver][SQL Server]Login failed for user 'sa'
    ====================

  2. #2
    Join Date
    Sep 2003
    Posts
    522
    check what authentication method your msde is using and make sure that standard security is available.

  3. #3
    Join Date
    Oct 2003
    Posts
    8
    Thanks ms_sql_dba

    My MSDE use both WINDOWS/SQL Server authentication
    I check "LoginMode" value in REGISTRY it's = Zero which mean both

  4. #4
    Join Date
    Oct 2003
    Posts
    8
    Thanks ms_sql_dba

    My MSDE use both WINDOWS/SQL Server authentication
    I check "LoginMode" value in REGISTRY it's = Zero which mean both

  5. #5
    Join Date
    Oct 2003
    Posts
    8
    Up 4 Help

  6. #6
    Join Date
    Oct 2003
    Posts
    8

    Wink

    I found the Solution in Archive which guide me to this link:
    http://www.dbforums.com/showthread.php?threadid=711306

    The Solution is very simple:
    Change "SA" password

    use this command line in DOS:
    osql -Q"exec sp_password null,'newpassword','sa'" -E

Posting Permissions

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