Sunroofs are very hard to get sealed and I leave it to an auto trim shop to do. They do it every day and know the tricks. Good luck.
I plan to caulk mine shut. THe repair estimate was $9k.
A common problem with the 2000 Toyota Camry is sunroof drain clogs and leaks. These can be repaired through the dealership.
does the rear sunroof glass have drain holes
In your sunroof there should be 1 hole in each corner. These holes act as drains for the sunroof. Every sunroof leaks, the drains let the water drop out of the vehicle at the bottom on the underside. Your drain holes are probably just plug up, maybe with leaves or something. Grab an air compressor and a hose and just blow the blockage out.
repair it or get a new one.
I you happen to have a sunroof--check the two drain plugs which you can access when the sunroof is open. thry may be clogged. there are plastic tubes that run downward, which a wire can be inserted into to clean them out. hope this helps out.
you can try putting silicon where it leaks i did this to my Truck with a sunroof i put silicon on the top but the con about this that i cant open the sunroof
repair the leak
Find where it is running out and repair the cause.
If there are no visible leaks....a blown head gasket.
check to make sure it is the sunroof for one, 2nd after your sure, replace the rubber seal, 40 bucks i think, the rubber gets old and the window wont set down onto it properly anymore, also if you have gallon of water in the back seat but roof isn't wet, its not the sunroof, its the front window leaking down the frame rails then into the back seat, my sunroof leaks barely, but made me think the gallons in back seat was it, it was not the source of the heavy leaks, anyhow, hope it helps ya...
For one of Miles' challenges, he askes you to find leaks around the barnyard and repair them. All the leaks look the same, so you won't have to worry about trying to find different looking ones. Most of the leaks are found around by the perimeter of the barnyard. (From what I remember there are no leaks anywhere else, just the barnyard.) Follow the fence of the barnyard around the whole entire space until you repair all the leaks.