0

I have sql server 2008 R2. Everytime I create new sql server authorization login, whatever password I write it was changed to unknown me 15 characters password. Same is for sa. So I can't lofin with sql server authorization.I login with windows authorization and I have sysadmin permissions. How can I fixed that?

Michael Hampton
  • 244,070
  • 43
  • 506
  • 972
Aram Gevorgyan
  • 119
  • 1
  • 3

1 Answers1

0

Make sure Enforce Password Policy is not enabled

In other words

CREATE LOGIN loginName WITH PASSWORD = '<enterStrongPasswordHere>', 
CHECK_POLICY = OFF;

Also is SQL Server running in Mixed Mode?

SQLMenace
  • 391
  • 4
  • 4