All, I'm embarrassed to report the following... After nearly pulling the plug on this POC using windows server, i decided to start from the very beginning, basically "is it plugged in". While doing so, i discovered that I had fat fingered ip addresses in the Host File, which led to issues with the installation. After correcting the host IP addresses, i was able to successfully reinstall HDP common, Hive, Oozie, HBase. Configuration: 2 windows servers (01 and 02) Options: HDP Common, HBase, Hive and Oozie with MSSQL Metastore ~could never get DerbyServer to work Modified Hive-Site.xml Set dataNucleus.autoCreateSchema and dataNucleus.validateTables to True Note: While monitoring the Hive and Hiveserver2 test, i noticed the test was blocked by an open connection from hive. It was an idle connection that prevented the hive test from creating the missing tables, like TBL_Privs. ... View more

After a lot of trial and error, I finally got the installation to work. Here's what i did differently. 1. Launch the msi using a local account with admin rights, not a domain account. 2. For the Hadoop - User password, i entered a very strong password that was sure to meet Windows min requirements. 3. selected derby to host Hive and Oozie dbs, not MSSQL. 4. DID NOT select LZO, GZip, or Oozie web console options. My theory is the installation failed due to either insufficient system privileges related to my domain account or the password entered for the hadoop user failed the minimum requirements for Server 2012. Now my next challenge is to install / configure a compression codec and the oozie web console after the fact. I appreciate everyone's help earlier. ... View more