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:46 am

    #1928666

    I can confirm what John says about the password. On SQL 2000, passwords were case-insensitive, if the server collation was case-insensitive. This was changed in SQL 2005.

    If the application uppercasess all letters, that sounds a little crazy, but I have no alternative explantion to offer.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]