Home Forums SQL Server 2008 Security (SS2K8) migrated to sql 2008 R2 from an old sql 2000 database using compatibility mode, some passwords don't work anymore RE: migrated to sql 2008 R2 from an old sql 2000 database using compatibility mode, some passwords don't work anymore

  • February 15, 2017 at 9:06 am

    #1928643

    stephen.hare - Wednesday, February 15, 2017 8:49 AM

    Everything seems fine except, the login from the app (using odbc) will fail if we put regular LOWER case characters (a,b,c,d,e,f...etc) in there.

    Steve

    In where?  I don't really understand. Is the login and/or password hard-coded in the application?  Are you saying you don't have access to either or both of them?  Is the login set up on the new server?

    If I remember correctly, SQL login passwords in SQL Server 2000 were only case-sensitive if the server collation was case-sensitive.

    John