How does Microsoft Dynamics GP work with Advanced SQL Server Options?

When creating Microsoft Dynamics GP users, there is an option to utilize Advanced SQL Server Options, which include:

• Enforce Password Policy
• Enforce Password Expiration
• Change Password Next Login

How does SQL know what Password Policy to set and Enforce Password Expiration? 

The Policy comes from the Local SQL Machine’s Windows Policy. 

How can you verify the settings of the Local Windows Policy?

Type secpol.msc from Start>Run.  This opens the Local Security Settings.  Go to Security Settings>Account Policies>Password Policy.  This is where you will find password policies that will be applied if utilizing Advanced SQL Server Options.

If you are having issues with Microsoft Dynamics GP user logins, KnowledgeBase article #919345 has some great information as well.