web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / DYNSA User cannot crea...
Microsoft Dynamics GP (Archived)

DYNSA User cannot create/save Dynamics Users

(0) ShareShare
ReportReport
Posted on by U079310 405

Running V9 Dynamics GP system.  When logged on as SA user the Save button on the User Setup screen works just fine.  However when logging on as the user DYNSA the Save button is grayed out.   The Dynamics and Company db are both owned by the DYNSA user.   Ideas ?

 Rick

*This post is locked for comments

I have the same question (0)
  • John Carpenter Profile Picture
    John Carpenter 280 on at
    Re: DYNSA User cannot create/save Dynamics Users

     On the SQL server, open SQL management studio, then open the properties page of the DYNSA logon under security>logons.  Under Server Roles check the dbcreator role and the security administrator role.  This will allow DYNSA to do users.

     Note that you are granting an advance server privledge to DYNSA.

    Regards.

    JC

  • Community Member Profile Picture
    Community Member on at
    Re: DYNSA User cannot create/save Dynamics Users

    What you have said is correct.  Only the 'SA' user can create and delete users.  This has to do with the permissions in the database and SQL as much as it does with GP.  This seems to be a built in limitation Microsoft added in version 8 or 9.  To the best of my knowledge this cannot be changed, meaning the only user who can create new users is 'sa'.

    Joe

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans