AjarnJonesy
asked on
SSRS 2005 on server 2008 issues with running reports from new server in cluster
I have a SSRS 2005 report environment made up of 2 load balanced servers. One server has been up and running on its own for some time now.. However I recently rebuilt the second server with SSRS 2005 installed on windows 2008 64bit. I installed the instances with no real issues and then went to the original server and exported (backed up ) the encryption keys and restored to the new server that I just built. I was then able to connect to the instance and then run through the initialization process with no issue. However now that I can access the site on the new report server I get the following error when trying to run/open a report
An error has occurred during report processing. (rsProcessingAborted)
Cannot impersonate user for data source '10000A'. (rsErrorImpersonatingUser)
Logon failed. (rsLogonFailed)
Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)
Im not sure where to go with this error now. However some of the things that I can say are:
Windows Identity Service account is an AD account which is in the local Administrators group on both servers.
Web Service Identity Account is the same AD account and has been working on the original server for some time now.
SSRS 2005 SP4 CU 3 and the patch level is the same on both Servers.
I dont know if it matters or not but here is the entire stack trace from the Report Server Log. I would greatly appreciate any help as this is driving me up the wall..
at Microsoft.ReportingService s.ReportPr ocessing.R eportProce ssing.Repo rtRuntimeD ataSourceN ode.Proces s()
at Microsoft.ReportingService s.ReportPr ocessing.R eportProce ssing.Runt imeDataSou rceNode.Pr ocessConcu rrent(Obje ct threadSet)
w3wp!processing!8!9/17/201 3-23:59:57 :: i INFO: Merge abort handler called. Aborting data sources ...
w3wp!processing!8!9/17/201 3-23:59:57 :: e ERROR: Throwing Microsoft.ReportingService s.ReportPr ocessing.P rocessingA bortedExce ption: An error has occurred during report processing., ;
Info: Microsoft.ReportingService s.ReportPr ocessing.P rocessingA bortedExce ption: An error has occurred during report processing. ---> Microsoft.ReportingService s.ReportPr ocessing.R eportProce ssingExcep tion: Cannot impersonate user for data source '10000A'. ---> Microsoft.ReportingService s.Diagnost ics.Utilit ies.LogonF ailedExcep tion: Logon failed. ---> System.Runtime.InteropServ ices.COMEx ception (0x80070569): Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)
at System.Runtime.InteropServ ices.Marsh al.ThrowEx ceptionFor HRInternal (Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLo gon.GetRem oteImpToke n(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingService s.Diagnost ics.Impers onationCon text.Login (Credentia lsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
--- End of inner exception stack trace ---
BTW.. Thanks in advance:)
An error has occurred during report processing. (rsProcessingAborted)
Cannot impersonate user for data source '10000A'. (rsErrorImpersonatingUser)
Logon failed. (rsLogonFailed)
Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)
Im not sure where to go with this error now. However some of the things that I can say are:
Windows Identity Service account is an AD account which is in the local Administrators group on both servers.
Web Service Identity Account is the same AD account and has been working on the original server for some time now.
SSRS 2005 SP4 CU 3 and the patch level is the same on both Servers.
I dont know if it matters or not but here is the entire stack trace from the Report Server Log. I would greatly appreciate any help as this is driving me up the wall..
at Microsoft.ReportingService
at Microsoft.ReportingService
w3wp!processing!8!9/17/201
w3wp!processing!8!9/17/201
Info: Microsoft.ReportingService
at System.Runtime.InteropServ
at RSRemoteRpcClient.RemoteLo
at Microsoft.ReportingService
--- End of inner exception stack trace ---
BTW.. Thanks in advance:)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.