The 4 mounting bolts should be snug but not really torqued down. Too much torque merely compresses the roof structure.
Water runs readily at the slightest downhill grade, so the leak could be anywhere uphill of the places you saw the water. I would not leap to the conclusion the a/c is the source, even though it definitely needs to be tightened.
2004 American Tradition; 2014 Buick LaCRosse
Homebase in the Ocala Nat'l Forest near Ocala, FL