I don’t know about the one that bolts onto the roof or what glue you are using but prepping the area and using the correct glue should hold up. Auto parts stores sell specific rear view mirror glue. The windshield and the mirror attachment pad should both be free of all residue and oils before the glue is applied. Use denatured alcohol and a lint free cloth as a final cleaning step. Follow directions and cure times and you should be good. Also it might be helpful to adjust the mirror by grabbing the center and not one of the outside edges.
$.02
$.02