Allow other user than SA to change passwords and access to companies

Posted on 2010-01-04
Last Modified: 2013-12-11
Is there a way to allow another user than SA in GP to change users passwords or give access to different companies. Users forget the password or lock themselves out and we would like the IT helpdesk to deal with the password issues but we do not want to give the SA password to helpdesk staff due to security reasons.
Any suggestions?
Question by:JanFverhoeve
    LVL 18

    Accepted Solution


    That's a good question.  I just tried several different tests, and from what I can tell, there is only one way to allow someone other than 'sa' change the login.  I think it may work, but there may be a caveat that I'm missing.

    Create a new GP login, and then only give that login access to the GP User Setup window.  (In GP 10, this should be easier than GP 9)

    Then go into SQL Server Management Studio and add that login to the sysadmin server role.  GP checks to see if a login is a member of the sysadmin role to determine whether to enable the Save button on the User Setup window.

    The user would then be able to login to GP, would only have access to the User Setup window, and would be able to change the GP passwords.

    Because the login was created in GP, the user would not be able to use that login with SQL Server Management Studio, which I believe would prevent them from accessing anything on the SQL Server directly.

    I think this would work, but as I said, there could be a few details I'm missing at the moment.

    Let me know if that makes sense, and if you have any questions.


    Steve Endow
    Dynamics GP Certified Trainer
    Dynamics GP Certified Professional


    Author Comment

    Thanks a lot for your suggestion. Tried it and it worked as expected and solves my problem.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
    Article by: Leon
    Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now