Post reply

Login failed for user ''SA'' ?

  • May 22, 2005 at 7:45 am

    #164634

    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?

  • May 23, 2005 at 3:25 am

    #560443

    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:

    http://www.databasejournal.com/features/mssql/article.php/3461471

  • May 27, 2005 at 9:11 am

    #561530

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

  • May 29, 2005 at 11:46 pm

    #561646

    Thanks but I have checked password complexity rules

  • May 29, 2005 at 11:47 pm

    #561647

    Thanks I have checked mixed authentication

  • May 13, 2008 at 9:41 am

    #814613

    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