Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / What may cause this er...
Microsoft Dynamics GP (Archived)

What may cause this error ?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

When i am creating a new user in GP, I face this error message What may cause this error ?

Please advice...

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: What may cause this error ?

    So it was the other way around? The user existed in GP but not in SQL? Normally I try not to have spaces in user IDs. Not that this was the problem here. So somehowm this user was in the Dynamics User Table but not in SQL. Is it possible that someone went into SQL and deleted this user for some reason? All security needs to done inside GP for GP.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What may cause this error ?

    Thanks for your reply, the corresponding user does not have a sql login. But the user is present in the GP company database and the dynamics database. Before i delete the user i noted what are all task and roll assigned for the particular user. After that i delete the user. Now i can create the same user without any issue.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: What may cause this error ?

    You would not be able to enter a user ID on this screen if you were not logged in as 'sa'. As I said earlier, it appears your databases were copied from another server and this user ID is inside SQL but not in GP. The other possibility is that you have a user with the same windows credentials username as GP username. Please go into SSMS and the security for SQL and also each database and check the user list. I am sure you are going to find a duplicate. They need to be removed before you can add them with GP.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What may cause this error ?

    Sill i get a same error

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What may cause this error ?

    Hi David

                  Yes i logged in as SA.

  • davidf. Profile Picture
    davidf. on at
    RE: What may cause this error ?

    Are you logged in as SA when creating the account? It's possible you may not have adequate rights in SQL *and* GP to create the account.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: What may cause this error ?

    This database was probably copied from another server. You need to have someone go into SSMS and clear the user account you are trying to add from both SQL and the company databases to which you want to add it.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans