Hi All, Thanks in advance... I have question regarding encryption key that i have already in my production server.. Right now if I want to reset password for user with sql authentication and I’m using 5 character encrypted password and it's giving me error for windows policy.. my question is that can i make new encrypted password with 8 character? I have right now Symmetric keys on my master DB. Name: ##MS_ServiceMasterKey##, Principal _id:1, Symmetric_key_id:102,Key_lenght:128,Key_algorithm:D3,algorithm_desc:TRPLE_DEC then it's create date and modify date..
Your SMK has nothing to do with the user's password requirements. You are not adhering to the password policies of the O/S. If you want a shorter password you have to de-select the **Enforce password policy** checkbox in the user's properties. Of course this means a less secure password being used.