Solved

"Deleting Login Failed for an Unknown Reason" message in Dynamics GP 8.0

Posted on 2009-07-02
2
3,490 Views
Last Modified: 2013-12-11
When removing old Users from Dynamics there are a couple of users where we get the message "Deleting Login Failed for an Unknown Reason". Can anyone point me to the Tables to remove these users from?
0
Comment
Question by:TomAlford
  • 2
2 Comments
 
LVL 18

Accepted Solution

by:
Steve Endow earned 500 total points
ID: 24764639
Hi Tom,

It's been a while since I ran into this error, but there are a few possible causes.  One cause is that the user you are trying to delete has permissions in other SQL databases outside of GP.  Another is that the user exists in GP, but the SQL login or database user has already been deleted from SQL.

Another cause of this problem is when databases are migrated from one SQL Server to another (i.e. test or QA environment, or a new server build), which causes the SQL user SIDs / GUIDs to be different, actually preventing you from seeing the logins and users in the SQL tools on the new server.

My experience has been that it is typically an issue with SQL logins and users, and not with the user information in the Dynamics GP tables, but your situation could be either.

This issue is discussed in KB Article 943027, which should be accessible to you through Customer Source if you are current on  your enhancement plan.

Are you using SQL 2005 or SQL 2000?  (I don't remember if GP 8 worked with 2005, so I'll give you the scripts for both)

You can try the following and see which, if any of these work.  Before performing any of these steps, you should perform full backups of your master database, Dynamics database, and company databases.


1a) Run this script while logged in as 'sa' against the Dynamics DB and each company DB:

SQL 2005:  DROP USER <User_name>
SQL 2000:  sp_dropuser <User_name>

1b) Then run this script:

SQL 2005:

USE master
GO
DROP LOGIN <Login_name>

SQL 2000:

USE master
GO
sp_droplogin <Login_name>


After running these scripts, login to Dynamics GP as 'sa', and then select the user from the User Setup window.

When you select or enter the user ID, you may get an error that the user does not have a SQL login, which is fine.

Then click Delete to try and remove the user.


If that doesn't work, you can also try these scripts in the Dynamics database.  These are for Dynamics GP 9, but hopefully they work or are similar enough to 8 that it gives you something to start with.

 DELETE DYNAMICS..SY01400 WHERE USERID = '<User_name>'
DELETE DYNAMICS..ACTIVITY WHERE USERID = '<User_name>'
DELETE DYNAMICS..SY02000 WHERE USERID = '<User_name>'
DELETE DYNAMICS..SY60100 WHERE USERID = '<User_name>'


Let me know if any of these fix your problem, or if you run into any complications.  If you have any additional questions, just let me know.

Steve Endow
Dynamics GP MCT

0
 
LVL 18

Expert Comment

by:Steve Endow
ID: 24826882
Hi Tom,

Did this help resolve your issue with the logins?

Steve Endow
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

A frequent question here in the MAS90 Zone is, How do you get data out of MAS90 for analysis, reporting or using the data on your web pages?   This is an introductory level tutorial to getting data out of MAS90 using ODBC. Data can be accessed by…
If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now