Deletion of Solomon User

• 05-23-2008 3:56 PM

  jefboo Joined on 05-23-2008 Posts 5

  Deletion of Solomon User Reply Contact 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?

• 05-29-2008 7:03 AM

  In reply to

  csims9158 Joined on 03-24-2008 Posts 4	Re: Deletion of Solomon User Reply Contact 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.

• 05-29-2008 9:20 AM

  In reply to

  jefboo Joined on 05-23-2008 Posts 5

  Re: Deletion of Solomon User Reply Contact 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.

• 05-29-2008 9:57 AM

  In reply to

  jefboo Joined on 05-23-2008 Posts 5	Re: Deletion of Solomon User Reply Contact 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.