Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / gp server crash
Microsoft Dynamics GP (Archived)

gp server crash

(0) ShareShare
ReportReport
Posted on by Community Member

I have a customer that had their GP server crash. They have restored their GP databases to a new server. I added the DYNSA SQL login and then setup the permissions for DYNSA. I then made DYNSA the owner of all of the GP databases. I am able to log into GP as the sa user. Since all of the GP userids are still in the DYNAMICS db, I deleted one user's userid from all of the GP databases and DYNAMICS. I then gave the user a new password so that GP would create the SQL login for the user.

My question is this. Is there an easy way to remove the GP userid from each of the company databases and DYNAMICS db? They have about 25 users and 11 company databases so remove the userids manually is quite tedious. Unfortunately there is no way to run the capture_sql_logins script to recreate the logins.

Also is there anything I am missing in respect to getting them back up and running? I am running the grant.sql script against the GP databases. I trying to cover everything that I would normally do when moving GP to a new server.

Thanks,

Bill

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: gp server crash

    Just as a comment, I do not think the Macro approach will work. Since you restored to a new server, the User Ids exist in the Great Plains Databases but they do not exist in the master database...believe will error out. What you can do is open SSMS...open each Great Plains database, click security...then Go to the SSMS toolbar select View>Object Explorer Details...all your users will appear in the window where you can select multiple accounts at a time using excel select options. After selecting..right click and delete.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: gp server crash

    Hi William,

    If you want to delete the users from GP, go to  Tools-->Setup-->System-->User to open User setup screen.

    1) record a Macro to delete a dummy user.

    2) collect total number of user list for each company in GP.

    3) use Mail merge technique, you can generate macro\macro's from the user list sheet.

    4) run the respective macro to delete overall user's in GP.

    same way you can create users also.

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans