web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / User Setup Error
Microsoft Dynamics GP (Archived)

User Setup Error

(0) ShareShare
ReportReport
Posted on by kbnyny 290

We have GP 2010 SQL 2008.

When I go to add a new User under User Setup, I am able to put in all the user information. When I go to save the new user I am getting and error msg "The creation of the login failed for an unknown reason. Contact your SQL Server Administrator for assistance.

Do anyone have any idea why I am getting this error? I am getting this error when  Iog in as SA and DYNSA. Below is the error screen I am getting.

Thanks in advance.
Kevin

*This post is locked for comments

I have the same question (0)
  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at
    Re: User Setup Error

    SQL Server 2008 is require complex password? Can you check that user is already exist in Dynamics GP and in Production Database?

    Thanks

    Sandip

  • kbnyny Profile Picture
    kbnyny 290 on at
    Re: User Setup Error

    Yes I did make the password complex. If the password is not complex it will tell you the password does not meet the system requirements. No user exist by the name in Dynamics GP or any Production DB.  

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    Re: User Setup Error

    Were your databases copied from another server? This sounds like the User ID is attached to the database but does not exist in GP. Please go into SSMS and look at security for both Dynamcs and company. If this user ID exists on these databases delete them from the databases and try again. Also, note the the GP User ID cannot match their Windows credentials ID. So if for any reason you have given the domain user access to these databases you will need to use a different name in GP.

  • kbnyny Profile Picture
    kbnyny 290 on at
    Re: User Setup Error

    The db was not copy it is a production db on production server. I have looked in SSMS and the User ID is not attached to any of the databases. The user window credentials ID is not the same as the GP User ID.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    Re: User Setup Error

    Do you see this user ID just under security for this instance of SQL?

    You could also try to unclick the option to Enforce Password Requirements just to see if the SQL account gets created. Are you logged into GP as 'sa' as you are trying this?

  • kbnyny Profile Picture
    kbnyny 290 on at
    Re: User Setup Error

    The User ID is NOT under security for the instance of SQL.

    Yes I am log in as SA.

    I will try to unclick the enforce password requirements and see if that helps.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    Re: User Setup Error

    Hi,

    I've seen this error many times, here's what I've done to make it go away.

    First, look at 'Security Logins' in Microsoft SQL Server Management Studio to see if the user has a sql Login. Then, look at each database uder 'Security' to see if the user exists there. If you delete the user from SQL as well as the databases, you should be able to add them when you bring the user up in User Maintenance.

    Kind regards,

    Leslie

  • kbnyny Profile Picture
    kbnyny 290 on at
    Re: User Setup Error

    I have looked in each database under security and there is no login for the new user I was trying to add.

    Any other suggestiion?

    Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    Re: User Setup Error

    Can you do this on the server? I am wondering if the SQL client you are using is causing this problem. So you cannot add any users, correct?

  • kbnyny Profile Picture
    kbnyny 290 on at
    Re: User Setup Error

    Me nor the Accounting Manager can not setup any user in GP via the User Setup Window.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans