[David Morinello]

GP 2018 Web Services
Over the last few weeks I started seeing this error in my DEV, QA, & Staging environments. Restoring a SQL backup of the DynamicsGPSecurity Database solves it, but I would like to understand the root cause.

If the database were truly Invalid, why does GP Web Services continue to work? Any Ideas?

Tests

• While opening the GP Web Services Configuration Wizard (to add a new company), I have started seeing this error below.
• Repairing the Web Services for Microsoft Dynamics GP 2018 fails with an error
• Accessing the Dynamics Security or Exception Consoles both work ok
• Stopping & Restarting the Microsoft Dynamics GP Service Host stops and starts ok. Does not fix the error

Repairing

——————————
David Morinello
Senior Dynamics GP Systems Architect
Ascend Learning, LLC
Leawood KS
——————————

[David Morinello]

Got it!
It looks like my DB Team added some SQL users to the DynamicsGPSecurity database. I removed those users and I could use the GP Web Services Configuration Wizard without error.

Reference
https://community.dynamics.com/gp/f/microsoft-dynamics-gp-forum/90975/gp-2010-web-services-install-error—-the-security-id-structure-is-invalid-exception-from-hresult-0x80070539

——————————
David Morinello
Senior Dynamics GP Systems Architect
Ascend Learning, LLC
Leawood KS
——————————
——————————————-