It depends on the tank and the placement of the tank but the recommendation is to have the tank as level as possible. Over time if the tank remains uneven and not level the force of the water can put undue stress on the seams of the aquarium and eventually cause the seals to break and cause leaking. In fact I just had this happen to me with a ten gallon tank I have had in my bedroom for years only to wake up one Sunday morning to find the tank leaking all over the floor. Fortunately I had planned to replace this aquarium with a 16 gallon that I had ready and waiting to be set up in it's place. So down came the ten gallon and up went the 16 gallon. Really though, my biggest worry would be the risk of an eventual leak, usually at the most inoppurtune moment.
Marinemom