- License removal from non existent AD account
- Posted by John Holleman on March 1st, 2005
Hi-
Does anyone know of a way to remove a CRM Sales license from a user who is
still listed in the CRM system, but not in AD? The associated AD user
account was deleted prior to the CRM admin removing the license. Please
advise if there is another way to do this besides an AD single object
restore.
TIA
John Holleman
- Posted by Kelly on March 1st, 2005
Yes, I had this same issue happen. Here is the fix that I
received from Microsoft CRM Support:
You will need your CRM license key
You will need to be able to log into the domain and into
Microsoft CRM as a user with System Administrator
privileges.
1. Exit all users from Microsoft CRM - I'd suggest doing
this after hours.
2. Remove the license from your deployment. This is done
on the CRM Server.
a. In Deployment Manager (Start, Programs, Microsoft CRM,
Deployment Manager), expand the License Manager node on
the left side of the window.
b. Highlight the organization name. The right side of the
window should display your License Type, the number of
users and your License Key. Print this e-mail so you can
type the License Key in a later step.
c. Right-click the entry that has this information and
choose Delete License from the context menu.
3. Add the license back in the same window.
a. Right-click the blank area in the window and choose
New, License.
b. Type your license key in the License Key field, then
finish the wizard by clicking Next and Finish.
4. In Microsoft CRM, add the license back to the existing
users.
a. Launch Microsoft CRM as a user with System
Administrator privileges.
b. Click the Settings side tab on the Home Page, then
click Business Unit Settings, then click Users.
c. For every user (one at a time), open the User record,
click the Licenses side tab, then click Manage Licenses,
and add the Sales Standard license to each user.
ADDITIONAL INFORMATION:
We recommend that you do not delete CRM Users out of
Active Directory before reassigning their records and
taking their CRM License away. Adding the User back into
AD creates a new Security ID (SID) for the user, which
does not match the SID associated with the existing CRM
User (even though they might have the same login
information). The system is looking for the old SID in AD
when attempting to remove the license.
- Posted by John Holleman on March 1st, 2005
Thanks much Kelly-
I'll give this a shot later tonight.
Regards,
John
Yes, I had this same issue happen. Here is the fix that I
received from Microsoft CRM Support:
You will need your CRM license key
You will need to be able to log into the domain and into
Microsoft CRM as a user with System Administrator
privileges.
1. Exit all users from Microsoft CRM - I'd suggest doing
this after hours.
2. Remove the license from your deployment. This is done
on the CRM Server.
a. In Deployment Manager (Start, Programs, Microsoft CRM,
Deployment Manager), expand the License Manager node on
the left side of the window.
b. Highlight the organization name. The right side of the
window should display your License Type, the number of
users and your License Key. Print this e-mail so you can
type the License Key in a later step.
c. Right-click the entry that has this information and
choose Delete License from the context menu.
3. Add the license back in the same window.
a. Right-click the blank area in the window and choose
New, License.
b. Type your license key in the License Key field, then
finish the wizard by clicking Next and Finish.
4. In Microsoft CRM, add the license back to the existing
users.
a. Launch Microsoft CRM as a user with System
Administrator privileges.
b. Click the Settings side tab on the Home Page, then
click Business Unit Settings, then click Users.
c. For every user (one at a time), open the User record,
click the Licenses side tab, then click Manage Licenses,
and add the Sales Standard license to each user.
ADDITIONAL INFORMATION:
We recommend that you do not delete CRM Users out of
Active Directory before reassigning their records and
taking their CRM License away. Adding the User back into
AD creates a new Security ID (SID) for the user, which
does not match the SID associated with the existing CRM
User (even though they might have the same login
information). The system is looking for the old SID in AD
when attempting to remove the license.
- Posted by Matt Parks on March 2nd, 2005
There is a much easier way, though it is unsupported, but if you have a lot of
users, definately worth it.
The table you are interetsed in is the SystemUserLicenses table. You also eed
to look at SystemUserbase to see what the SystemUserId is for the user in
question. Then, delete the corresponding row(s) from SystemUserLicenses for
that same SysstemUserId value.
Make sure to backup your database first though, just in case. In fact, a simple
copy of the table you are modifying should suffice.
Matt Parks
MVP - Microsoft CRM
----------------------------------------
----------------------------------------
On Tue, 1 Mar 2005 14:51:22 -0800, "Kelly" <anonymous@discussions.microsoft.com>
wrote:
Yes, I had this same issue happen. Here is the fix that I
received from Microsoft CRM Support:
You will need your CRM license key
You will need to be able to log into the domain and into
Microsoft CRM as a user with System Administrator
privileges.
1. Exit all users from Microsoft CRM - I'd suggest doing
this after hours.
2. Remove the license from your deployment. This is done
on the CRM Server.
a. In Deployment Manager (Start, Programs, Microsoft CRM,
Deployment Manager), expand the License Manager node on
the left side of the window.
b. Highlight the organization name. The right side of the
window should display your License Type, the number of
users and your License Key. Print this e-mail so you can
type the License Key in a later step.
c. Right-click the entry that has this information and
choose Delete License from the context menu.
3. Add the license back in the same window.
a. Right-click the blank area in the window and choose
New, License.
b. Type your license key in the License Key field, then
finish the wizard by clicking Next and Finish.
4. In Microsoft CRM, add the license back to the existing
users.
a. Launch Microsoft CRM as a user with System
Administrator privileges.
b. Click the Settings side tab on the Home Page, then
click Business Unit Settings, then click Users.
c. For every user (one at a time), open the User record,
click the Licenses side tab, then click Manage Licenses,
and add the Sales Standard license to each user.
ADDITIONAL INFORMATION:
We recommend that you do not delete CRM Users out of
Active Directory before reassigning their records and
taking their CRM License away. Adding the User back into
AD creates a new Security ID (SID) for the user, which
does not match the SID associated with the existing CRM
User (even though they might have the same login
information). The system is looking for the old SID in AD
when attempting to remove the license.
