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
Thank you Syed.
Hello Syed,
Has this issue been resolved now through a regular support case, or are you still working on it?
Thanks,
Hi,
Just to confirm are you installing web services using SA account and run as admin.
You can open a support case through Partnersource or Customersource, or by calling 1-888-477-7877.
I see the error is during the install of Web Services code. I still can't find any mention of ever seeing this error message. It'll probably be best if we look at it with you via a support case.
By the way, our regular support hours are 8:00am to 5:00pm CST for Dynamics GP, just so you're aware of that.
Thanks
When exactly does this error occur, when you're installing the Web Services 2013 R2 code, or when you run the Configuration Wizard, to install onto the GP databases?
Is this a new install or an upgrade of Web Services? (i.e. Is there any records in the WSInstallStatus table, or does this table even exist in the DYNAMICS system database, before you began this Web Services installation?)
On the web server, logged on as your admin account, when you re-create this error, if you click on Start > Run, type in %TEMP% and click OK to open your TEMP directory, are there any log files created for the Web Services installation? If so, that may give us more information.
Other than making sure that the DYNSA is the db_owner of all GP 2013 R2 databases and that the DYNSA account has the SecurityAdmin and DBCreator roles assigned to it for SQL Server, we'd probably need a support case, as we've never seen this error that I'm able to find in our case history, so it definitely appears to be environmental, which can sometimes be tough to pinpoint.
Thanks
So, to be on the same page...am assuming...
1. you went to sql server security at the server level ( not at the DB level) and selected the windows user account
2. and then login properties >> Server Roles>> selected "sysadmin"
3. then User Mapping >> Marked master, msdb, Dynamics and Company DB and made sure that the column "Default Schema" has the "dbo" selected not the windows user id
4. Also made sure that DYNGRP role is marked on all these DBs.
To me, based on the error message it looks purely a SQL server permission issue. If this didn't resolve the issue, then please open up a support case as Derek suggested.
Also, you can enable the SQL server tracing with all the necessary events(both Starting and Completed) marked and check, as that might tell you what DDL statement it tries to execute and fail.
Derek,
Thank you very much for your kind attention. I am having a single machine install ( GP+SQL+WebService) and account I am using is use all times for all admin tasks.
to knock off all the possibilities
it did create the Security DB for the first time, so I am keeping it and no removing every time I retry
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
