Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Server Migration
Finance | Project Operations, Human Resources, ...
Suggested answer

Server Migration

(0) ShareShare
ReportReport
Posted on by Sunil Chhabra 1,930

I moved GP databases to a new server. Did not run the capturelogins script. But per GP I can reset the the password and then "script out" the login - Not sure what is meant by this

pastedimage1660855631807v1.png

Since we only have 3 users - i deleted inactivated the existing users and then created new 3 users.

The issue that I am running into is I am unable to delete 2 of 3 existing users - from GP - I removed them from sql  from the GP databases but they still appear in GP - I get an error when I try to delete them.

Secondly I am not able to make DYNSA the DBOwner. I get an error message dynsa does not exist - when it is there.

The users are able to login using their new userid - but I would like to get rid of the old inactive users and resolve the DYNSA user issue.

Thanks

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Server Migration

    Have you looked at the Dynamics..Activity table - that will show you the users still connected to GP.

    If the users you are trying to delete were attached to the system when you made the move to the new server - they are still apparently attached to the database on the new server.

    Removed them from the Activity table and see if that resolves the problem.

    Derek gives you the detailed steps to complete this task

    David M gives you a tool to complete this task.

    Pick one method and it should be able to accomplish what you need done.

  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Server Migration

    >>If you're not able to delete the GP user through the User Setup window within Dynamics GP, you can manually remove them from these tables:

    DELETE DYNAMICS..SY01400 WHERE USERID = '<User_name>'

    DELETE DYNAMICS..ACTIVITY WHERE USERID = '<User_name>'

    DELETE DYNAMICS..SY60100 WHERE USERID = '<User_name>'

    DELETE DYNAMICS..SY10500 WHERE USERID = '<User_name>'

    DELETE DYNAMICS..SY10550 WHERE USERID = '<User_name>'

    The SY01400 is the User Master table and the SY60100 is the User Access table.

    The SY10500 and SY10550 table are the user security tables.

    >>If you need to remove the users from SQL Server, look under each of the GP system and company databases, under 'Users' to make sure any of these inactive users no longer exist there.

     Also, under Security > Logins, you can verify whether the user/login exists or not as well.

     The following script can also be run against the GP databases:

           sp_dropuser '<User_Name>'

     This script can be run against the Master system database to remove the login:

           sp_droplogin '<Login_Name>'

    The information above should completely remove the user from both Dynamics GP and SQL Server to the point where they could be re-added if at ever needed.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,928 Most Valuable Professional on at
    RE: Server Migration

    Database Validation can fix all the issues with mismatched users and DYNSA.

    It can fix the DYNSA user and assign it as the owner of the databases.

    It can either remove or recreate damaged users

    Database-Validation-Users.png

  • Sunil Chhabra Profile Picture
    Sunil Chhabra 1,930 on at
    RE: Server Migration

    This is great - but since the migration is already done and  new users have been created.   How can this  assist in the current issue of not being able to get rid of users that appear in GP but are in SQL databases. Also DYNSA is there but not functional.

    Thanks

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,928 Most Valuable Professional on at
    RE: Server Migration

    FYI: GP Power Tools Database validation fixes all of the issues you had in seconds.

    https://winthropdc.wordpress.com/2015/08/12/gppt-whats-new-database-validation-copying-databases-and-upgrades/

    Regards

    David

  • Sunil Chhabra Profile Picture
    Sunil Chhabra 1,930 on at
    RE: Server Migration

    everything is installed on the new server - databases restored. Followed the KB article (except for the capture logins). According to the KB if did not use Capture logins you will just need to reset the password - well that did not work. GP is up and running - setup 3 new users - just want to get rid of the old users and not sure when I try to assign sp_changedbowner 'DYNSA'  - i get an error dynsa not found. when it is there.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Server Migration

    You need to install GP on this server first and then run GP Utilities. There are a few miscellaneous things that need to be performed first. You do not need to create any companies.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Server Migration

    Have you looked at the Dynamics..Activity table - that will show you the users still connected to GP.

    If the users you are trying to delete were attached to the system when you made the move to the new server - they are still apparently attached to the database on the new server.

    Removed them from the Activity table and see if that resolves the problem.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans