Notifications
Announcements
Hello:
Does a member of the SL Administrators Group need the SQL Server "sysadmin" Role to add Dynamics SL Users?
Thanks,
Mike
*This post is locked for comments
In a word... yes.
In order to add a Windows Authenticated User, SL needs to create a SQL login, map it to both the APP and SYS database and add the application role. These actions combined generally means sysadmin: access to both databases, login creation, and role assignment. You might work it out with a combination of securityadmin, db_accessadmin et al, but you'll end up with a powerful role anyhow.
If you want to separate the DBA role, in theory a SQL script could be built to perform the required steps.
Windows authentication is a recent addition to SL and it's still kind of patched up.
Thank you Erich!
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
