Solved

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

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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
timeslip.cfg cannot be found 3 1,824
Quicken 2005 error code 7214 3 360
Great Plain (GP 2010) - Accounts Payable Transaction Inquiry 3 234
User Account Control Message for Sage 50 3 220
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…
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. …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

777 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