question

AnthonyNeu-6249 avatar image
0 Votes"
AnthonyNeu-6249 asked Joyzhao-MSFT edited

SSRS Users names in web interface do not match database

I have an issue where the usernames in my SSRS web portal do not match the usernames in the reportserver database. I am unable to add\delete users as we migrated the users from one domain to another. Now SSRS give me the below errors:

The user or group name 'US\DMTAdmin' is not recognized.

126185-image.png



the above windows security group was changed from one domain to another. We are collapsing subdomains.

the interface is still showing the old AD name. The ssrs users table, however is showing the new domain

I have restarted ssrs services and restarted the ssrs report server. What can i do to ensure the webportal is seeing the actual user name? How can i correct the error as i cannot add\delete users from my report server now.

sql-server-reporting-services
image.png (12.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @AnthonyNeu-6249
Is your username in the new domain the same as before? Have you previously set the storage user name and password in the browser when opening the web portal?
What is the user name to connect to the report server database in the configuration manager? Please try to reconfigure the database connection information and Web Portal URL in the configuration manager, and restart the report server.
Usually we can view the database authentication information in the rs.config file, but we do not recommend to modify it directly in the file. The best way is to make changes through the report server configuration manager.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.