Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to setup Password ...
Microsoft Dynamics GP (Archived)

How to setup Password Policies for SQL Server Login

(0) ShareShare
ReportReport
Posted on by Community Member

We just upgraded to GP 2013R2 and want to use the advanced setting to enforce password policies.  Actually, our preference would be to use Windows/AD authentication, but it appears that we cannot do that since we don't use the Web Version?  Am I right/wrong?  

Anyway, going through the forum posts, I saw a few references to 'Understanding the Password Policy..."  https://support.microsoft.com/en-us/kb/2028712 and looked at the White Paper (for SQL Server 2005) there, but didn't see anything that provides step-by-step instructions for any version - we would be particularly interested in those for SQL Server 2008R2.   

Any advice?   

*This post is locked for comments

  • Suggested answer
    Tom Cruse Profile Picture
    Tom Cruse 1,477 on at
    RE: How to setup Password Policies for SQL Server Login

    Mary,

    Ditto to Mahmoud and Rosemary's response. To answer your other question about utilizing your AD credentials, yes that is only for the WebClient, when properly setup, Desktop application is SQL login only.

    Tom

  • Rosemary Profile Picture
    Rosemary 4 on at
    RE: How to setup Password Policies for SQL Server Login

    Hi Mary, we currently use GP 2013, and as Mahmoud indicated as long as you tick the option to 'enforce password policy' it will maintain the same policies as Active Directory

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: How to setup Password Policies for SQL Server Login

    Hello Marry

    Once you enable the password policy by marking the "Enforce password policy" on the user setup window, it will force users to adhere to the same password policies that have been established on the Windows Server domain.

    For that, check Active Directory Password Policy

    Additional options in the user setup window are:

    Change Password Next Login

    Mark this option to force users to change their passwords the next time they log in to Microsoft Dynamics GP. The Enforce Password Policy must be marked for this option to be available.

    Enforce Password Expiration

    Mark this option to force users to change their passwords after the number of days that is defined by the Windows Server domain password policies. This option is available only if you have marked the Enforce Password Policy option.The Enforce Password Policy must be marked for this option to be available

    Furthermore, you do need to take a look at Mariano article on Enforcing Password Policy with Dynamics GP

    Your feedback is highly appreciated,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans