Call 855-644-2677 for Microsoft Dynamics GP / SL Support, Training, and Implementation

How to fix “The creation of the login failed for an unknown reason…” error in Microsoft Dynamics GP

September 14, 2016 11:31 am Published by
[indeed-social-media sm_list='fb,tw,goo,li' sm_template='ism_template_8' sm_list_align='horizontal' sm_display_counts='true' sm_display_full_name='false' ]

Have you ever received the following error message when trying to create a new login for a new user in Microsoft Dynamics GP?

How to fix "The creation of the login failed for an unknown reason…" error in Microsoft Dynamics GP

The error message reads, “The creation of the login failed for an unknown reason. Contact your SQL Server administrator for assistance.” There are several potential reasons for the error, the most likely being that the user is already added to the database, but not added to your Microsoft Dynamics GP or your SQL level logins. Microsoft has addressed this error message on their Dynamics Community website in the past. Their initial suggestion was as follows:

“There could be several reasons for this. Are you familiar with SSMS? You will need to go into GP and look at the logins for this database. Look to see if this user already exists. If it does, delete it and try again. Make sure it does not exist in SQL either.”

You will also have to delete such a login from each company’s database. Check every database on the SQL server for the problem logins, then delete them. This problem can arise if someone tries to create a user in SQL, as users should always be created in Microsoft Dynamics GP.

This login deletion solution will clear up the problem for most people. However, if you read through the linked webpage, you will see that some people are still getting this message even with completely new users that have not already been added to another database. A mystery? Well, on his Microsoft Dynamics GP blog, Mohammad Daoud seems to have solved it.

In one case he was delving into, Daoud ultimately found that the users had a DDL trigger at the server level that tracked changes to logins, then sent emails to administrators informing them about the changes. The trigger was causing the error, so Daoud solved the problem by simply disabling the trigger.

About MIG & Co.

MIG & Co. is a professional consulting firm that specializes in the implementation of business management software solutions, including Microsoft Dynamics GP, SL, and CRM. We automate business processes to ensure that our customers work efficiently. MIG is a Microsoft Dynamics Gold Certified Partner.

Ready to learn how Microsoft Dynamics can help your business?

Talk to an Expert
  • This field is for validation purposes and should be left unchanged.

MIG & Co.