we are migrating our database and report server from SQL 2005 to SQL 2012 and we have move DB to new server.
i have configured the reporting server to AD user. We also have deployed reports to SQL 2012 reporting server.
recently installed SQL 2012 SP1 on this machine.
when we configured report server , we were able to get reports from application side without any problem.
we have refresh our db recently and now when we call reports from application site we are facing below error.
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'xxxx'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Any idea what setting we have to change, i also tried using execution account but not luck.
i check that AD user we are using, is a DB_owner of the accessing DB.
Any help will be appreciated