btamulis 1/29/2025 12:47:46 PM

GP Dynamics without sysadmin in SQL?

Here's the deal - my client would like to have a fully functioning GP QA environment that mirrors their GP Production environment.

They want no SQL logins to be 'sysadmin' - if fact I think they were quite surprised that GP Production environment does have a sysadmin (sa) account that is used in connectivity and within the GP interface (create new users) etc.

Anybody have GP running without a single active SQL sysadmin account?

Version: All
Section: Dynamics GP


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3