Getting the error when installing web services
Getting the error when installing web services
All,
Thanks for the suggestions. I figured out the issue, I was doing a migration and I forgot to restore one of the DBs, which resulted in this error. Once I restored the DB, it worked fine.
Thanks Much
Thanks for the clarification on that Derek.
I was more answering from not having the DYNGRP database role at all, but you're correct in that we normally don't want to be manually changing the core security objects like DYNGRP at all.
During the install of Web Services, it does put objects such as tables, views and stored procedures into the GP databases and thus needs to add those permissions to DYNGRP, which is what I'm thinking it does when the above error shows.
Nothing we commonly see when installing Web Services.
Thanks
I was wondering before answering - Why do you need / want to change the role of a Core Dynamics security object? Maybe I am not asking with the right words - but I am thinking that out of the box the Role is created and defined - and there is a reason that all users are add to the group.
Just me being curious.
In SQL, if you look under Security > Roles > Database Roles, under each GP system and company database, do you see the DYNGRP database role present?
If not, you can use a script like this to create it:
CREATE ROLE [DYNGRP]
Then, run the Grant.sql script for Dynamics GP against it, on all GP databases, which will give it the SELECT, INSERT, UPDATE and DELETE permissions for the GP tables and views, and EXECUTE permissions for stored procedures.
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156