You’re offline. This is a read only version of the page.
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
Thank you Erich!
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.
#1
André Arnaud de Cal...
294,118
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
