Thank You very much for your reply Perry and SQLBuddy

Yes, this SQL server is in active directory group. I don’t want to change password policy on domain.

Here is my situation, all domain accounts are already enforced with password policy(8 Char alphanumeric, and changing every 90 days) . Management is discouraging local accounts usage on SQL servers so they want to implement a new policy for non –AD accounts with 16char.

Can we have a local policy on SQL servers only for specific accounts (non-AD accounts).? Is it possible in SQL server (2008 R2)..?

Thanks,

Murali