Duct tape does not really work unless you cover the whole thing along the roof surround and the gap at the edge of the glass. But it will eventually get in! There are two edges you need to seal on each roof.
Are you sure its the roof drains leaking? Windscreen seals are also known to let...