OpsMgr 2012 SP1: Cannot Install OpsMgr due to OperationsManagerDW database files in a non default location for User Databases – Error Code: 0x80131500

I ran into this issue where the RMSe Installation would fail at the Data warehouse configuration during Operations Manager Setup. Issue: The install fails at the DW installation….and a warning is seen for the Management Server Install, then subsequent red X Critical Failures below. OS versions = Server 2012 STD SQL version = SQL 2012…