User cannot access Crystal reports after user was deleted and recreated

[Former Member]

We are using Crystal Enterprise XIr2. We are using Windows AD authentication. We had an issue with a user where they were deleted in Active Directory. Now they can no longer run Crystal reports. When I go into the CMC and open users I see this user. When I try to open this user I get the following error

There was an error while retrieving data from the server: Active Directory Authentication failed to get the Active Directory groups for the account with ID "8B003DF11D45B244AC3B61AB36B6C445:ALLENDG". Please make sure this account is valid and belongs to an accessible domain.

I think Crystal is still trying to access the user's old Active Directory account.

I cannot delete the user either in CMC.

Is there someway I can correct this user.

Thanks

Adam

[Former Member]

Hi Adam,

Did you try to delete the ALIAS for the user and try agian ? if not, please try and let us know.

Thanks,

Arjun

[Former Member]

Arjun,

Can you tell me when I can delete the Alias

Adam

[Former Member]

In CMC --> goto Users and Groups --> select or search the user from the USER list -->Double Click on the User or goto User Properties --> If you see ALIAS for Windows AD for the user, delete it and recreate it again using NEW ALIAS button or ask the user to login again.

Thanks,

Arjun

[Former Member]

From the User list when I click on the user I get the message below so I am not able to get into the user to delete an alias.

There was an error while retrieving data from the server: Active Directory Authentication failed to get the Active Directory groups for the account with ID "8B003DF11D45B244AC3B61AB36B6C445:ALLENDG". Please make sure this account is valid and belongs to an accessible domain

[Former Member]

Windows AD Group graph update job is running on your system ? If not, please Try this

In CMC--> Public Folder --> Administration Tools

In administration tool, there are two objects

1) Update Windows AD Group Graph

2) Update Windows AD Group Graph and Aliases --> Right click on this Report and click on RUN Now.

Removed AD users gets updated automatically with the Windows AD Group graph update job.

Thanks,

Arjun

[Former Member]

Arjun - Thank you for your help. I looked in Central Management Console but I could not find what you indicated.

CMC--> Public Folder --> Administration Tools

In administration tool, there are two objects

1) Update Windows AD Group Graph

2) Update Windows AD Group Graph and Aliases --> Right click on this Report and click on RUN Now.

I ended up deleting the records for this user in these SQL tables and then user could access InfoView

CMS_Aliases5 (2 records for this user)

CMS_InfoObjects5 (1 record with both aliases)