Solved

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

Posted on 2009-07-02
2
3,516 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hi, I've just fixed a problem with Sage 50 Accounts 2010 crashing when creating a new Company.  I've spent nearly 4 hours on it including three calls to the Sage helpdesk (they didn't work it out in the end - I did!) ... so I thought I'd share th…
Getting data out of MAS90 doesn’t have to be tedious or time consuming.  With any version of Excel using the included Microsoft Query function, you can access just about any data set or combination of data sets stored in your MAS90 MAS200 Software. …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

830 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