Login failed for user ''SA'' ?

  • I use an application that connects through ODBC with login:sa - password:xyz.

    It connects both to local and network installation (MSDE and Standard 2000).

    I have upgraded both SqlServers to 2005 CTP with the same authentication modes and passwords.

    The network connection works but the local does not with error message:

    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SA'

    Any idea?

  • Hello,

    a few weeks ago i've been in an event explaining the main differences between the SQL 2000 and the SQL 2005,

    and one thing discussed, was the lenght of passwords,

    in 2000 there was no restrictions, but in SQL 2005, the users password need at least 6 characteres.

    you can see on this link an explanation of major differences on security:


  • By chance is your database instance set up for Windows Only authentication (instead of Mixed)?

  • Thanks but I have checked password complexity rules
  • Thanks I have checked mixed authentication

  • I just installed per vendor request Windows only authentication for SQL 2005. I no longer have access to 'sa' user.

    Is there a way to change the authentication without re-installing?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply