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..