I keep getting the following login failed for the Application Name: SMS_MP_FILE_DISPATCH_MANAGER
Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database 'dbName'. [CLIENT: <local machine>]
First, where does the mpfdm.log located on the SQL Server reporting server services? Second, what else could have caused this login error?
