The user or group name ‘domain_name\user_name’ is not recognized when deploying SSRS report

When you have backup database from other environment and you want to use it in another server, you could not just restore and use those snap away.

Recently, i have an error when trying to redeploy to Reporting Server. Here we go :

An error occurred while deploying reports and artifacts.
Error: The user or group name ‘domain_name\user_name’ is not recognized.

What i do is :

I delete records in SysServerSession table from SQL Server. All records which has no connection with current Active Directory. After that restart the AOS, then finish !!🙂

These steps, took me couple days to find. Meanwhile my head getting headache every time my team asked me ‘have you find the solution ?’

But its all done now..

About this entry