Microsoft, SQL, 2000, SQL 2005 Reporting Services, Logon failed. (rsLogonFailed)

We have a MSSQL 2000 Server and a MSSQL 2005 Reporting Server.  The reporting server has been running great with the 2000 backend up until recently.

Recently, because of the departure of a systems administrator, we changed the domain administrator password.  When that happened the reporting server started giving login errors.  Here is what you see at the web front end when trying to run a report:

Logon failed. (rsLogonFailed)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

Here is what is in the log when a report is attempted:

w3wp!webserver!6!10/31/2007-11:14:39:: i INFO: Reporting Web Server started
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing ProcessRecycleOptions to '0'  as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'  as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'  as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
w3wp!library!6!10/31/2007-11:14:39:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
w3wp!resourceutilities!6!10/31/2007-11:14:39:: i INFO: Reporting Services starting SKU: Enterprise
w3wp!resourceutilities!6!10/31/2007-11:14:39:: i INFO: Evaluation copy: 0 days left
w3wp!runningjobs!6!10/31/2007-11:14:39:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds.  Cycle: 600 seconds
w3wp!runningjobs!6!10/31/2007-11:14:39:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
w3wp!runningjobs!6!10/31/2007-11:14:39:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
w3wp!runningjobs!6!10/31/2007-11:14:39:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
w3wp!library!6!10/31/2007-11:14:41:: Call to GetPermissionsAction(/Accounting).
w3wp!library!6!10/31/2007-11:14:41:: i INFO: Catalog SQL Server Edition = Enterprise
w3wp!library!6!10/31/2007-11:14:41:: Call to GetPropertiesAction(/Accounting, PathBased).
w3wp!library!8!10/31/2007-11:14:41:: Call to GetSystemPermissionsAction().
w3wp!library!8!10/31/2007-11:14:42:: Call to ListChildrenAction(/Accounting, False).
w3wp!library!7!10/31/2007-11:14:42:: Call to GetSystemPropertiesAction().
w3wp!library!6!10/31/2007-11:14:42:: Call to GetSystemPropertiesAction().
w3wp!library!6!10/31/2007-11:14:50:: Call to GetPermissionsAction(/Accounting/Open Capital Assurant Claims with RO).
w3wp!library!8!10/31/2007-11:14:50:: Call to GetSystemPropertiesAction().
w3wp!library!8!10/31/2007-11:14:50:: Call to GetPropertiesAction(/Accounting/Open Capital Assurant Claims with RO, PathBased).
w3wp!library!6!10/31/2007-11:14:51:: Call to GetSystemPermissionsAction().
w3wp!library!8!10/31/2007-11:14:51:: Call to GetPropertiesAction(/Accounting/Open Capital Assurant Claims with RO, PathBased).
w3wp!library!8!10/31/2007-11:14:51:: Call to ListEventsAction().
w3wp!library!8!10/31/2007-11:14:52:: Call to GetSystemPropertiesAction().
w3wp!library!8!10/31/2007-11:14:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. ---> System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
   at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
   at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
   --- End of inner exception stack trace ---

I did rerun the Configure Reporting Server tool and the database does initialize.  However, there is the error "The Reporting Services rights were not applied properly.  The user may still not have appropriate access to the Reporting Services resources."  With the following details:

System.Data.SqlClient.SqlException: User does not have permission to perform this action.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
   at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)

Any suggestions will be appreciated.Start Free Trial