MSCRM 1.2 - Delete user

In my test lab, I added a domain user via the Deployment Management snap-in.
I later realized that the user's name was misspelled and deleted the account
from AD. The user however was not deleted from CRM. In the settings
portion of the CRM interface I saw the misspelled user and deleted him from
there and yet the user still appears in the Deployment Manager snap-in. How
can I delete or at least free up the license?

thanks,

Sean

GreaterThanTwo
Fri Feb 27 16:01:54 CST 2004

You can't delete users in CRM, but you can recover the license. Open the
user record under crm settings, go to licenses, click manage, and remove the
license.

Mike

greaterthantwo media
Printable Quotes, Orders and Invoices, with line-item details, now available
for MSCRM.
http://www.greaterthantwo.com


"HelpPls" <smd6169@hotmail.com> wrote in message
news:e8CYZoX$DHA.3668@TK2MSFTNGP09.phx.gbl...
> In my test lab, I added a domain user via the Deployment Management
snap-in.
> I later realized that the user's name was misspelled and deleted the
account
> from AD. The user however was not deleted from CRM. In the settings
> portion of the CRM interface I saw the misspelled user and deleted him
from
> there and yet the user still appears in the Deployment Manager snap-in.
How
> can I delete or at least free up the license?
>
> thanks,
>
> Sean
>
>

Jeff
Fri Feb 27 23:04:31 CST 2004

That is correct Mike but smd6169 deleted the user from AD
already. If he/she tries to remove the license there will
be an error message indicating the user object does not
exist in AD and will not be able to recover the license.

The only way to correct this is to restore the AD prior
to deleting the user & then remove the license ( besides
un-install/re-install MSCRM ).

I learned the hard way about this so don't feel too
bad....

>-----Original Message-----
>You can't delete users in CRM, but you can recover the
license. Open the
>user record under crm settings, go to licenses, click
manage, and remove the
>license.
>
>Mike
>
>greaterthantwo media
>Printable Quotes, Orders and Invoices, with line-item
details, now available
>for MSCRM.
>http://www.greaterthantwo.com
>
>
>"HelpPls" <smd6169@hotmail.com> wrote in message
>news:e8CYZoX$DHA.3668@TK2MSFTNGP09.phx.gbl...
>> In my test lab, I added a domain user via the
Deployment Management
>snap-in.
>> I later realized that the user's name was misspelled
and deleted the
>account
>> from AD. The user however was not deleted from CRM.
In the settings
>> portion of the CRM interface I saw the misspelled user
and deleted him
>from
>> there and yet the user still appears in the Deployment
Manager snap-in.
>How
>> can I delete or at least free up the license?
>>
>> thanks,
>>
>> Sean
>>
>>
>
>
>.
>

HelpPls
Mon Mar 01 08:40:19 CST 2004

Yes- I was getting the error indicating the user does not exist. A complete
reinstall, unbelievable. I hope they correct this issue and allow us to
simply DELETE a user and manage their license.

Thanks for your help....

"Jeff" <anonymous@discussions.microsoft.com> wrote in message
news:3cca01c3fdb8$5987d5f0$a101280a@phx.gbl...
> That is correct Mike but smd6169 deleted the user from AD
> already. If he/she tries to remove the license there will
> be an error message indicating the user object does not
> exist in AD and will not be able to recover the license.
>
> The only way to correct this is to restore the AD prior
> to deleting the user & then remove the license ( besides
> un-install/re-install MSCRM ).
>
> I learned the hard way about this so don't feel too
> bad....
>
> >-----Original Message-----
> >You can't delete users in CRM, but you can recover the
> license. Open the
> >user record under crm settings, go to licenses, click
> manage, and remove the
> >license.
> >
> >Mike
> >
> >greaterthantwo media
> >Printable Quotes, Orders and Invoices, with line-item
> details, now available
> >for MSCRM.
> >http://www.greaterthantwo.com
> >
> >
> >"HelpPls" <smd6169@hotmail.com> wrote in message
> >news:e8CYZoX$DHA.3668@TK2MSFTNGP09.phx.gbl...
> >> In my test lab, I added a domain user via the
> Deployment Management
> >snap-in.
> >> I later realized that the user's name was misspelled
> and deleted the
> >account
> >> from AD. The user however was not deleted from CRM.
> In the settings
> >> portion of the CRM interface I saw the misspelled user
> and deleted him
> >from
> >> there and yet the user still appears in the Deployment
> Manager snap-in.
> >How
> >> can I delete or at least free up the license?
> >>
> >> thanks,
> >>
> >> Sean
> >>
> >>
> >
> >
> >.
> >

Matt
Mon Mar 01 11:03:27 CST 2004

Another option (though it's usupported) is to look at the tables in
the MSCRM database. If you get the user's GID from SystemUserBase,
you can then manually remove the license entry from the
SystemUserLicense (pretty sure that's that name) table.

NOTE: If you know this user doesn't own any records in the system,
you can also remove the SystemUserBase record in a similar manner.
You may get some FK constraint errors that will prompt you to remove
data from other tables first.

I HIGHLY recommend a DB backup before trying this so you can go back
if you need to.

Matt

On Mon, 1 Mar 2004 09:40:19 -0500, "HelpPls" <smd6169@hotmail.com>
wrote:

Yes- I was getting the error indicating the user does not exist. A
complete
reinstall, unbelievable. I hope they correct this issue and allow us
to
simply DELETE a user and manage their license.

Thanks for your help....

"Jeff" <anonymous@discussions.microsoft.com> wrote in message
news:3cca01c3fdb8$5987d5f0$a101280a@phx.gbl...
> That is correct Mike but smd6169 deleted the user from AD
> already. If he/she tries to remove the license there will
> be an error message indicating the user object does not
> exist in AD and will not be able to recover the license.
>
> The only way to correct this is to restore the AD prior
> to deleting the user & then remove the license ( besides
> un-install/re-install MSCRM ).
>
> I learned the hard way about this so don't feel too
> bad....
>
> >-----Original Message-----
> >You can't delete users in CRM, but you can recover the
> license. Open the
> >user record under crm settings, go to licenses, click
> manage, and remove the
> >license.
> >
> >Mike
> >
> >greaterthantwo media
> >Printable Quotes, Orders and Invoices, with line-item
> details, now available
> >for MSCRM.
> >http://www.greaterthantwo.com
> >
> >
> >"HelpPls" <smd6169@hotmail.com> wrote in message
> >news:e8CYZoX$DHA.3668@TK2MSFTNGP09.phx.gbl...
> >> In my test lab, I added a domain user via the
> Deployment Management
> >snap-in.
> >> I later realized that the user's name was misspelled
> and deleted the
> >account
> >> from AD. The user however was not deleted from CRM.
> In the settings
> >> portion of the CRM interface I saw the misspelled user
> and deleted him
> >from
> >> there and yet the user still appears in the Deployment
> Manager snap-in.
> >How
> >> can I delete or at least free up the license?
> >>
> >> thanks,
> >>
> >> Sean
> >>
> >>
> >
> >
> >.
> >

GreaterThanTwo
Mon Mar 01 11:05:17 CST 2004

You could just go into the DB and manually remove the license from the user.
Not supported, but it's a lot easier than re-installing :)

Mike

greaterthantwo media
Printable Quotes, Orders and Invoices, with line-item details, now available
for MSCRM.
http://www.greaterthantwo.com


"Jeff" <anonymous@discussions.microsoft.com> wrote in message
news:3cca01c3fdb8$5987d5f0$a101280a@phx.gbl...
> That is correct Mike but smd6169 deleted the user from AD
> already. If he/she tries to remove the license there will
> be an error message indicating the user object does not
> exist in AD and will not be able to recover the license.
>
> The only way to correct this is to restore the AD prior
> to deleting the user & then remove the license ( besides
> un-install/re-install MSCRM ).
>
> I learned the hard way about this so don't feel too
> bad....
>
> >-----Original Message-----
> >You can't delete users in CRM, but you can recover the
> license. Open the
> >user record under crm settings, go to licenses, click
> manage, and remove the
> >license.
> >
> >Mike
> >
> >greaterthantwo media
> >Printable Quotes, Orders and Invoices, with line-item
> details, now available
> >for MSCRM.
> >http://www.greaterthantwo.com
> >
> >
> >"HelpPls" <smd6169@hotmail.com> wrote in message
> >news:e8CYZoX$DHA.3668@TK2MSFTNGP09.phx.gbl...
> >> In my test lab, I added a domain user via the
> Deployment Management
> >snap-in.
> >> I later realized that the user's name was misspelled
> and deleted the
> >account
> >> from AD. The user however was not deleted from CRM.
> In the settings
> >> portion of the CRM interface I saw the misspelled user
> and deleted him
> >from
> >> there and yet the user still appears in the Deployment
> Manager snap-in.
> >How
> >> can I delete or at least free up the license?
> >>
> >> thanks,
> >>
> >> Sean
> >>
> >>
> >
> >
> >.
> >

HelpPls
Tue Mar 02 13:23:38 CST 2004

The CRM installation is for testing so I don't mind doing something
"unsupported" however, where in the SQL would I find/delete the user?

Thanks all - Sean
"GreaterThanTwo Media" <nospam_info@greaterthantwo.com> wrote in message
news:e0Tre96$DHA.2448@TK2MSFTNGP12.phx.gbl...
> You could just go into the DB and manually remove the license from the
user.
> Not supported, but it's a lot easier than re-installing :)
>
> Mike
>
> greaterthantwo media
> Printable Quotes, Orders and Invoices, with line-item details, now
available
> for MSCRM.
> http://www.greaterthantwo.com
>
>
> "Jeff" <anonymous@discussions.microsoft.com> wrote in message
> news:3cca01c3fdb8$5987d5f0$a101280a@phx.gbl...
> > That is correct Mike but smd6169 deleted the user from AD
> > already. If he/she tries to remove the license there will
> > be an error message indicating the user object does not
> > exist in AD and will not be able to recover the license.
> >
> > The only way to correct this is to restore the AD prior
> > to deleting the user & then remove the license ( besides
> > un-install/re-install MSCRM ).
> >
> > I learned the hard way about this so don't feel too
> > bad....
> >
> > >-----Original Message-----
> > >You can't delete users in CRM, but you can recover the
> > license. Open the
> > >user record under crm settings, go to licenses, click
> > manage, and remove the
> > >license.
> > >
> > >Mike
> > >
> > >greaterthantwo media
> > >Printable Quotes, Orders and Invoices, with line-item
> > details, now available
> > >for MSCRM.
> > >http://www.greaterthantwo.com
> > >
> > >
> > >"HelpPls" <smd6169@hotmail.com> wrote in message
> > >news:e8CYZoX$DHA.3668@TK2MSFTNGP09.phx.gbl...
> > >> In my test lab, I added a domain user via the
> > Deployment Management
> > >snap-in.
> > >> I later realized that the user's name was misspelled
> > and deleted the
> > >account
> > >> from AD. The user however was not deleted from CRM.
> > In the settings
> > >> portion of the CRM interface I saw the misspelled user
> > and deleted him
> > >from
> > >> there and yet the user still appears in the Deployment
> > Manager snap-in.
> > >How
> > >> can I delete or at least free up the license?
> > >>
> > >> thanks,
> > >>
> > >> Sean
> > >>
> > >>
> > >
> > >
> > >.
> > >
>
>

GreaterThanTwo
Tue Mar 02 14:25:15 CST 2004

SystemUserBase table

Mike


"HelpPls" <smd6169@hotmail.com> wrote in message
news:eXsUevIAEHA.2308@tk2msftngp13.phx.gbl...
> The CRM installation is for testing so I don't mind doing something
> "unsupported" however, where in the SQL would I find/delete the user?
>
> Thanks all - Sean
> "GreaterThanTwo Media" <nospam_info@greaterthantwo.com> wrote in message
> news:e0Tre96$DHA.2448@TK2MSFTNGP12.phx.gbl...
> > You could just go into the DB and manually remove the license from the
> user.
> > Not supported, but it's a lot easier than re-installing :)
> >
> > Mike
> >
> > greaterthantwo media
> > Printable Quotes, Orders and Invoices, with line-item details, now
> available
> > for MSCRM.
> > http://www.greaterthantwo.com
> >
> >
> > "Jeff" <anonymous@discussions.microsoft.com> wrote in message
> > news:3cca01c3fdb8$5987d5f0$a101280a@phx.gbl...
> > > That is correct Mike but smd6169 deleted the user from AD
> > > already. If he/she tries to remove the license there will
> > > be an error message indicating the user object does not
> > > exist in AD and will not be able to recover the license.
> > >
> > > The only way to correct this is to restore the AD prior
> > > to deleting the user & then remove the license ( besides
> > > un-install/re-install MSCRM ).
> > >
> > > I learned the hard way about this so don't feel too
> > > bad....
> > >
> > > >-----Original Message-----
> > > >You can't delete users in CRM, but you can recover the
> > > license. Open the
> > > >user record under crm settings, go to licenses, click
> > > manage, and remove the
> > > >license.
> > > >
> > > >Mike
> > > >
> > > >greaterthantwo media
> > > >Printable Quotes, Orders and Invoices, with line-item
> > > details, now available
> > > >for MSCRM.
> > > >http://www.greaterthantwo.com
> > > >
> > > >
> > > >"HelpPls" <smd6169@hotmail.com> wrote in message
> > > >news:e8CYZoX$DHA.3668@TK2MSFTNGP09.phx.gbl...
> > > >> In my test lab, I added a domain user via the
> > > Deployment Management
> > > >snap-in.
> > > >> I later realized that the user's name was misspelled
> > > and deleted the
> > > >account
> > > >> from AD. The user however was not deleted from CRM.
> > > In the settings
> > > >> portion of the CRM interface I saw the misspelled user
> > > and deleted him
> > > >from
> > > >> there and yet the user still appears in the Deployment
> > > Manager snap-in.
> > > >How
> > > >> can I delete or at least free up the license?
> > > >>
> > > >> thanks,
> > > >>
> > > >> Sean
> > > >>
> > > >>
> > > >
> > > >
> > > >.
> > > >
> >
> >
>
>