|Web Client SQL Server Login window|
In GP 2013 R2, users accessing the web client exclusively no longer require a SQL account to access the underlying data in the system and company databases they have been assigned to. However, their Active Directory credentials must be associated to their Microsoft Dynamics GP account (stored in the Users Master table (SY01400). Access to data is afforded via a common SQL Server login once the Active Directory credentials and the Microsoft Dynamics GP user credentials have been validated. This provides users with a single sign-on experience from the web client.
The above is described in more detail by Jason Lech, Escalation Engineer at Microsoft in his article on Identity Management.
Until next post!
Mariano Gomez, MVP
Intelligent Partnerships, LLC