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?
migrated from stackoverflow.com Apr 30 '11 at 5:47
This question came from our site for professional and enthusiast programmers.
In other words
Also is SQL Server running in Mixed Mode?