What astronomical bodies are most responsible for the tides on earth?

The moon and the sun, in that order. The moon is most important. The sun's tidal effect is about 44% as large as the moon's.

The alignment of sun, moon and earth determines tidal range . Highest and lowest tides occur close to full and new moon.