I had an issue with license and followed a recommended procedure of removing
and reinstalling the license. Now I have locked everyone out of CRM! I can't
add users through Deployment manager it gives me the error:

"The user has not been granted any licenses or the user has not been
assigned any roles (80042f09)"

I can not open CRM because there are no users installed.

I am running windows server 2003 w/sp1 and SQL with latest SP. Running CRM 1.2

Any help would be appreciated!

Re: Creating user after big mess up by John

John
Wed Aug 03 11:10:28 CDT 2005

Are you the admin of CRM. can you log onto the system with that account?

--
John O'Donnell
Microsoft CRM MVP
http://www.mscrmfaq.us


"Gary" <Gary@discussions.microsoft.com> wrote in message
news:D86CCCA9-63DC-43A6-9887-499473285C11@microsoft.com...
> I had an issue with license and followed a recommended procedure of
removing
> and reinstalling the license. Now I have locked everyone out of CRM! I
can't
> add users through Deployment manager it gives me the error:
>
> "The user has not been granted any licenses or the user has not been
> assigned any roles (80042f09)"
>
> I can not open CRM because there are no users installed.
>
> I am running windows server 2003 w/sp1 and SQL with latest SP. Running CRM
1.2
>
> Any help would be appreciated!



Re: Creating user after big mess up by Gary

Gary
Wed Aug 03 11:21:28 CDT 2005

The administrator account was renamed after the initial install of CRM a year
ago. When I try to login with the "admin" account it will not open Deployment
manager

"John O'Donnell" wrote:

> Are you the admin of CRM. can you log onto the system with that account?
>
> --
> John O'Donnell
> Microsoft CRM MVP
> http://www.mscrmfaq.us
>
>
> "Gary" <Gary@discussions.microsoft.com> wrote in message
> news:D86CCCA9-63DC-43A6-9887-499473285C11@microsoft.com...
> > I had an issue with license and followed a recommended procedure of
> removing
> > and reinstalling the license. Now I have locked everyone out of CRM! I
> can't
> > add users through Deployment manager it gives me the error:
> >
> > "The user has not been granted any licenses or the user has not been
> > assigned any roles (80042f09)"
> >
> > I can not open CRM because there are no users installed.
> >
> > I am running windows server 2003 w/sp1 and SQL with latest SP. Running CRM
> 1.2
> >
> > Any help would be appreciated!
>
>
>

Re: Creating user after big mess up by John

John
Wed Aug 03 11:31:24 CDT 2005

this sounds like one of those times where you have two options

1 - open a case with MBS support as this is a severe issue
2 - open the systemuserbase and add a license directly - may work but make
full database backups before trying this unsupported approach.

when you say there are no users installed do you mean there are no users
with licenses?

deployment manager should still show the users even if they do not have a
license. The systemuserbase table in the database should also show your
complete list of users - please check this

--
John O'Donnell
Microsoft CRM MVP
http://www.mscrmfaq.us


"Gary" <Gary@discussions.microsoft.com> wrote in message
news:81776DF7-24B7-4FC9-B25F-E49C88DEB810@microsoft.com...
> The administrator account was renamed after the initial install of CRM a
year
> ago. When I try to login with the "admin" account it will not open
Deployment
> manager
>
> "John O'Donnell" wrote:
>
> > Are you the admin of CRM. can you log onto the system with that account?
> >
> > --
> > John O'Donnell
> > Microsoft CRM MVP
> > http://www.mscrmfaq.us
> >
> >
> > "Gary" <Gary@discussions.microsoft.com> wrote in message
> > news:D86CCCA9-63DC-43A6-9887-499473285C11@microsoft.com...
> > > I had an issue with license and followed a recommended procedure of
> > removing
> > > and reinstalling the license. Now I have locked everyone out of CRM! I
> > can't
> > > add users through Deployment manager it gives me the error:
> > >
> > > "The user has not been granted any licenses or the user has not been
> > > assigned any roles (80042f09)"
> > >
> > > I can not open CRM because there are no users installed.
> > >
> > > I am running windows server 2003 w/sp1 and SQL with latest SP. Running
CRM
> > 1.2
> > >
> > > Any help would be appreciated!
> >
> >
> >



Re: Creating user after big mess up by Gary

Gary
Wed Aug 03 12:00:06 CDT 2005

It is working now. Thanks for the help. There were 2 system administrators,
myself and one other. For some reason I was locked out but he could get in.
Once he added a license for me I was able to login and adjust roles, etc.
Everything is running fine and for the record it is running much faster since
I blew out the old license holders and their user accounts.

"John O'Donnell" wrote:

> this sounds like one of those times where you have two options
>
> 1 - open a case with MBS support as this is a severe issue
> 2 - open the systemuserbase and add a license directly - may work but make
> full database backups before trying this unsupported approach.
>
> when you say there are no users installed do you mean there are no users
> with licenses?
>
> deployment manager should still show the users even if they do not have a
> license. The systemuserbase table in the database should also show your
> complete list of users - please check this
>
> --
> John O'Donnell
> Microsoft CRM MVP
> http://www.mscrmfaq.us
>
>
> "Gary" <Gary@discussions.microsoft.com> wrote in message
> news:81776DF7-24B7-4FC9-B25F-E49C88DEB810@microsoft.com...
> > The administrator account was renamed after the initial install of CRM a
> year
> > ago. When I try to login with the "admin" account it will not open
> Deployment
> > manager
> >
> > "John O'Donnell" wrote:
> >
> > > Are you the admin of CRM. can you log onto the system with that account?
> > >
> > > --
> > > John O'Donnell
> > > Microsoft CRM MVP
> > > http://www.mscrmfaq.us
> > >
> > >
> > > "Gary" <Gary@discussions.microsoft.com> wrote in message
> > > news:D86CCCA9-63DC-43A6-9887-499473285C11@microsoft.com...
> > > > I had an issue with license and followed a recommended procedure of
> > > removing
> > > > and reinstalling the license. Now I have locked everyone out of CRM! I
> > > can't
> > > > add users through Deployment manager it gives me the error:
> > > >
> > > > "The user has not been granted any licenses or the user has not been
> > > > assigned any roles (80042f09)"
> > > >
> > > > I can not open CRM because there are no users installed.
> > > >
> > > > I am running windows server 2003 w/sp1 and SQL with latest SP. Running
> CRM
> > > 1.2
> > > >
> > > > Any help would be appreciated!
> > >
> > >
> > >
>
>
>

Re: Creating user after big mess up by DavidJennaway

DavidJennaway
Wed Aug 03 12:02:05 CDT 2005

There's a reasonable chance that the problem comes from the admin account
having been renamed. If so, I'd try the completely unsupported hack of
changing the DomainName field in systemuserbase to reflect the new account

Something like the following would do:

Update systemuserbase
set DomainName = '<new admin account>'
where DomainName = '<old admin account>'

<... admin account> has to be in the format domain\username

As John says, before doing this, make sure you backup the MSCRM database


"John O'Donnell" wrote:

> this sounds like one of those times where you have two options
>
> 1 - open a case with MBS support as this is a severe issue
> 2 - open the systemuserbase and add a license directly - may work but make
> full database backups before trying this unsupported approach.
>
> when you say there are no users installed do you mean there are no users
> with licenses?
>
> deployment manager should still show the users even if they do not have a
> license. The systemuserbase table in the database should also show your
> complete list of users - please check this
>
> --
> John O'Donnell
> Microsoft CRM MVP
> http://www.mscrmfaq.us
>
>
> "Gary" <Gary@discussions.microsoft.com> wrote in message
> news:81776DF7-24B7-4FC9-B25F-E49C88DEB810@microsoft.com...
> > The administrator account was renamed after the initial install of CRM a
> year
> > ago. When I try to login with the "admin" account it will not open
> Deployment
> > manager
> >
> > "John O'Donnell" wrote:
> >
> > > Are you the admin of CRM. can you log onto the system with that account?
> > >
> > > --
> > > John O'Donnell
> > > Microsoft CRM MVP
> > > http://www.mscrmfaq.us
> > >
> > >
> > > "Gary" <Gary@discussions.microsoft.com> wrote in message
> > > news:D86CCCA9-63DC-43A6-9887-499473285C11@microsoft.com...
> > > > I had an issue with license and followed a recommended procedure of
> > > removing
> > > > and reinstalling the license. Now I have locked everyone out of CRM! I
> > > can't
> > > > add users through Deployment manager it gives me the error:
> > > >
> > > > "The user has not been granted any licenses or the user has not been
> > > > assigned any roles (80042f09)"
> > > >
> > > > I can not open CRM because there are no users installed.
> > > >
> > > > I am running windows server 2003 w/sp1 and SQL with latest SP. Running
> CRM
> > > 1.2
> > > >
> > > > Any help would be appreciated!
> > >
> > >
> > >
>
>
>