CMS user login Issue during Sitecore Upgrade

Recently while performing an upgrade from Sitecore 9.3 to Sitecore 10.3.0, we upgraded Sitecore 9.3 Core Database using Sitecore provide upgrade SQL scripts. On pointing this upgraded databases CMS user logins stopped working. After doing some research we found that we actually did not updated the core DB connection strings on all places which was causing the issues. So thought of writing this article to just summarize which all the connection strings should be update if are restoring Sitecore Core database from one environment to other.

CMS: core, security

CD: security

Sitecore Identity Server: SitecoreMembershipOptions connection string in file at path <SI Root>/Config/production/Sitecore.IdentityServer.Host.xml