1987828 - SAML SSO between HANA and BI failed due to "Assertion is not intended for this service provider"

Followed SAP note 1900023 to setup SAML SSO to HANA from BI, the SSO connection failed with the error:

• Connection Failed: The test of the HANA SSO ticket used to log onto the HANA DB has failed due to: [10]:invalid username or password: . (FWM 02133).
• Connection by Host and Port Failed: The test of the HANA SSO ticket used to log onto the HANA DB has failed due to: [10]: authentication failed. (FWM 02133)
• Connection by Host and Instance/Tenant Failed: The test of the HANA SSO ticket used to log onto the HANA DB has failed due to: [10]: authentication failed. (FWM 02133)

HANA authentication trace log contains error: SAMLAuthenticator.cpp(00387) : Assertion is not intended for this service provider

• SAP HANA (HANA SP09  or Higher)
• SAP BI 

SpID; SSO; SAML; SAP HANA; BI; SAMLAuthenticator; Authentication; , KBA , saml , HAN-DB-SEC , SAP HANA Security & User Management , Problem