Discussion:
Found SQLAccessGroup and PrivUserGroup missing
(too old to reply)
Austin
2008-05-22 22:57:00 UTC
Permalink
Both SQLAccessGroup {GUID} and PrivUserGroup {GUID} are missing so started
getting the following error.

" Exception type: DirectoryServicesCOMException
Exception message: There is no such object on the server."

What is this issue all about? What can be the workaround?
Thomas Arnold
2008-05-23 09:42:51 UTC
Permalink
Post by Austin
Both SQLAccessGroup {GUID} and PrivUserGroup {GUID} are missing so started
getting the following error.
"    Exception type: DirectoryServicesCOMException
    Exception message: There is no such object on the server."
What is this issue all about? What can be the workaround?
Hi Austin

Are the Groups missing in SQL Server or Active Directory? If in SQL
Server just add them in the SQL Mgtm Studio for the MSCRM_Config and
the <YOUR Organization>_MSCRM Database under Security as User.

Thomas
Austin
2008-05-23 18:51:06 UTC
Permalink
Hi Thomas,

Thanks for your response. I found these groups missing in AD. To further add
to the discussion, i created all 5 user groups in appropriate Organization
(OU) and still found these issue persisted. Even restarted IIS and SQL
server.

Yet to check the SQL Server for the access to the AD group against the
databse. I will check and get back to you.

Thanks,
Austi.
Post by Thomas Arnold
Post by Austin
Both SQLAccessGroup {GUID} and PrivUserGroup {GUID} are missing so started
getting the following error.
" Exception type: DirectoryServicesCOMException
Exception message: There is no such object on the server."
What is this issue all about? What can be the workaround?
Hi Austin
Are the Groups missing in SQL Server or Active Directory? If in SQL
Server just add them in the SQL Mgtm Studio for the MSCRM_Config and
the <YOUR Organization>_MSCRM Database under Security as User.
Thomas
Matt Parks
2008-05-23 19:13:40 UTC
Permalink
Are you using CRM 3 or 4? If you are using 3, then you will need to use the
Redeployment Wizard to recreate the needed DA objects and do the needed sync
between the DB and AD. CRM stores SID info from teh AD objects in the DB
and the groups you created have different SIDs. With v4, you will need to
basically do a clean install and then "import" the org database from your
installation.
--
Matt Parks
MVP - Dynamics CRM


"Austin" <***@discussions.microsoft.com> wrote in message news:9B3A11C9-5C32-4507-AAF2-***@microsoft.com...
Hi Thomas,

Thanks for your response. I found these groups missing in AD. To further add
to the discussion, i created all 5 user groups in appropriate Organization
(OU) and still found these issue persisted. Even restarted IIS and SQL
server.

Yet to check the SQL Server for the access to the AD group against the
databse. I will check and get back to you.

Thanks,
Austi.
Post by Thomas Arnold
Post by Austin
Both SQLAccessGroup {GUID} and PrivUserGroup {GUID} are missing so started
getting the following error.
" Exception type: DirectoryServicesCOMException
Exception message: There is no such object on the server."
What is this issue all about? What can be the workaround?
Hi Austin
Are the Groups missing in SQL Server or Active Directory? If in SQL
Server just add them in the SQL Mgtm Studio for the MSCRM_Config and
the <YOUR Organization>_MSCRM Database under Security as User.
Thomas
Jon Ezra
2011-05-20 21:56:29 UTC
Permalink
I ran into the same issue with a CRM 2011 installation. I tried everything but in the end the issue was actually caused by SQL 2008 R2 being in Mixed Authentication Mode rather than Windows Authentication mode. I changed the SQL instance properties, restarted the service and setup was able to continue without issue.
Post by Austin
Both SQLAccessGroup {GUID} and PrivUserGroup {GUID} are missing so started
getting the following error.
" Exception type: DirectoryServicesCOMException
Exception message: There is no such object on the server."
What is this issue all about? What can be the workaround?
Post by Austin
Hi Thomas,
Thanks for your response. I found these groups missing in AD. To further add
to the discussion, i created all 5 user groups in appropriate Organization
(OU) and still found these issue persisted. Even restarted IIS and SQL
server.
Yet to check the SQL Server for the access to the AD group against the
databse. I will check and get back to you.
Thanks,
Austi.
Post by Matt Parks
Are you using CRM 3 or 4? If you are using 3, then you will need to use the
Redeployment Wizard to recreate the needed DA objects and do the needed sync
between the DB and AD. CRM stores SID info from teh AD objects in the DB
and the groups you created have different SIDs. With v4, you will need to
basically do a clean install and then "import" the org database from your
installation.
--
Matt Parks
MVP - Dynamics CRM
Hi Thomas,
Thanks for your response. I found these groups missing in AD. To further add
to the discussion, i created all 5 user groups in appropriate Organization
(OU) and still found these issue persisted. Even restarted IIS and SQL
server.
Yet to check the SQL Server for the access to the AD group against the
databse. I will check and get back to you.
Thanks,
Austi.
Post by Thomas Arnold
Hi Austin
Are the Groups missing in SQL Server or Active Directory? If in SQL
Server just add them in the SQL Mgtm Studio for the MSCRM_Config and
the <YOUR Organization>_MSCRM Database under Security as User.
Thomas
Loading...