News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Cannot be added to one...

Finance | Project Operations, Human Resources, ...

Suggested answer

Cannot be added to one or more databases

(0) Share

Report

Report

Posted on by Richard Wheeler

75,730

We had another client get hacked so we had to do an emergency restore. At the end I got the all too common message " The user could not be added to one or more databases".

The fix in this case was to use SSMS to drop the users from all GP databases and then to add them back. I know about the steps in KB 929601. Has there been any thoughts about beefing up the scripts behind Tools->Setup->System->User Access to make all the necessary corrections? I find it odd that only rarely does this occur and when it does happens with a client with many users it becomes quite time consuming.

Categories:

Microsoft Dynamics GP

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Derek Albaugh on at

Like (0)

Report

RE: Cannot be added to one or more databases

You're correct in that this message is caused by SQL showing a user has access to a company database already while Dynamics GP doesn't reflect that setup.

As far as I'm aware, there isn't any talk to change the script behind the User Access window that would resolve this, though there were recently new functionality added to that window, so anything is possible.

I'd recommend adding this as a Product Suggestion and voting it up.

Thank you

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans