Furthermore you want your tank to be oriented at a 90-degree angle to the floor joists of the second floor - In other words, at the end of the joists where they rest on the load-bearing wall. That way the weight of tank/water/etc. will be spread across 3 or 4 or more floor joists, depending upon how close the joists are spaced.
