You can use standard tuning but most use Open D or Open G tuning. I tinker with my own Open D minor tuning. To each his own, really. A few examples:
My favorite slide song, Feeling Bad Blues by Ry Cooder uses Open D. Use this when you want a sad, dark feel.
Stevie Ray Vaughan used standard tuning and you'd use this if you want to sound really muddy and messy - but you have to be a better player than I to pull it off!
Open G makes for the happy, upbeat Chicago style. I believe that Foghat used this in Sweet Home Chicago but it could have been standard as well.
Duane Allman played the slide guitar on the Layla album and I believe he used Open D throughout -- so it's not so much the tuning as it is the incredible talent that Duane had.
I'm not sure about The Stones but Open D and Open G are a safe bet.