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) / Web Services Installat...
Microsoft Dynamics GP (Archived)

Web Services Installation Error

(0) ShareShare
ReportReport
Posted on by Syrus 4,156

I am trying to install Web Services for my GP 2013 R2 ( same machine where I have GP and SQL 2012) while all goes fine but ends up with an error saying, " Cannot alter the role 'DYNGRP' , because it does not exist or you do not have permission" and the installation rolls back

 

Any help will be appreciated very highly.

*This post is locked for comments

I have the same question (0)
  • Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,881 on at
    RE: Web Services Installation Error

    Are you trying to use DYNAMICS or a separate DB for WS Security. WS requires Windows user as the security database owner and so you cannot use DYNAMICS. Also, make the windows user as the DB Administrator and see if that works.

  • Syrus Profile Picture
    Syrus 4,156 on at
    RE: Web Services Installation Error

    Hi Jothikrishnan,

    • Thanks for your kind reply.
    • I am using GPWebServices and not Dynamics  for WS Security.
    • The account I am using is also DBowner for the above DB 

    any thoughts

  • Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,881 on at
    RE: Web Services Installation Error

    Syed, Can you assign the Role SecurityAdmin or Sysadmin to that Windows User ID you are using for installation in the Backend and see if that works. I'm guessing the windows user id does not have enough permission to the Dynamics and company database(s).

  • Syrus Profile Picture
    Syrus 4,156 on at
    RE: Web Services Installation Error

    Thanks again. I assigned all the roles and tried few admin accounts and even added/mapped these account for  "DYNGRP" group but still that message.

  • Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,881 on at
    RE: Web Services Installation Error

    Syed...Just before the installation fails and starts rolling back, can you see the new security database "GPWebServices" created?

  • Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,881 on at
    RE: Web Services Installation Error

    Also, make sure that the Default schema is "dbo" on all the databases(including master and msdb) for that Windows User account even though it has "Sysadmin" role assigned.

  • Syrus Profile Picture
    Syrus 4,156 on at
    RE: Web Services Installation Error

    Yes, it did create the "GPWebServices" DB when I tried first time.

  • Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,881 on at
    RE: Web Services Installation Error

    Please see the below...

    stackoverflow.com/.../how-to-add-an-user-to-sysadmin-role-using-alter-role

  • Syrus Profile Picture
    Syrus 4,156 on at
    RE: Web Services Installation Error

    what I have done now is assigned dbo for master and msdb for that user also server roles not DB roles. I am going to try again in  a while

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Web Services Installation Error

    Hello Syed,

    I haven't ever seen this error message when attempting to install Web Services for Dynamics GP 2013 R2 (or any version). The only thing I can think of, if you're still getting this error, is to make sure the account you're installing Web Services onto is an Administrator account on the web server as well as the SQL Server, if SQL is installed on a 2nd machine. If you don't find a resolution, we may need a support case opened so we can try to find and look at some installation logging as to what could be causing this error to occur.

    Let us know what you find.

    Thank you,

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