2179612 - BPC MS: Data manager packages will not run after changing BPC password and the TBLLOG table shows "Login failed for user"

After changing the BPC password inside BPC server managerm  data manager packages are not running anymore. 
No error occurs on the front end but an error will occur inside the TBLLOG table in the appserver database.

System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'IIS APPPOOL\SAP_BPC'.
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 

Business Planning and Consolidation for Microsoft 10.0 SP17 Patch 1

Data manager packages will not run after changing BPC password, "Login failed for user" Business Planning and Consolidation for Microsoft data manager package System.Data.SqlClient.SqlException (0x80131904) inside the TBLLOG table in the appserver database , KBA , defect , EPM-BPC-MS , Microsoft Version , Bug Filed