Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Report Processing login failed error From Application Expand / Collapse
Author
Message
Posted Tuesday, July 9, 2013 8:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 28, 2014 9:57 AM
Points: 23, Visits: 426
Hi,

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
Post #1471651
Posted Tuesday, July 9, 2013 8:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 28, 2014 9:57 AM
Points: 23, Visits: 426
it worked after re-deploying reports.
Post #1471660
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse