Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Deletion of Solomon User
Microsoft Dynamics SL (Archived)

Deletion of Solomon User

(0) ShareShare
ReportReport
Posted on by jefboo 40

Have been trying to delete a user in Solomon 7.0, but seem to get a SQL server message stating:

Name cannot be NULL

I can't find any documentation regarding this error on TechKnowledge.  Is this something that cannot be done.  I am not sure if this would be against Database practices regarding referential integrity.  Although if so I would think the error message would be more informative.  Has anyone had any luck with this?

*This post is locked for comments

  • jefboo Profile Picture
    jefboo 40 on at
    Re: Deletion of Solomon User

    NVM,  I got it.  I just assigned a valid AD user other than one that exists in Solomon and it worked.  Again thanks for the help.

  • jefboo Profile Picture
    jefboo 40 on at
    Re: Deletion of Solomon User
    Thanks for the reply.  That makes sense.  The issue that I am having with it though is that when you go to assign these users with a unique Windows User ID and domain, it has to be unique to that Solomon Userid.  These are users who do not exist any more in the company, so they do not exist in Active Directory.  Is there any other way around this, besides the obvious of adding these users back to AD, delete the user in Solomon, and then delete the AD user again.
  • csims9158 Profile Picture
    csims9158 320 on at
    Re: Deletion of Solomon User

    If you are using Windows Authentication on a database you have upgraded from a previous version, you will need to go into User Maintenance and assign a unique windows user id with domain for the user, tab through the field, and then it should let you delete that user.  You may have to save as well.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans