Lighting stained glass with spot light

I’m trying to light this room trough a stained glass roof.I read the documentation and from what i got you can only get this effect using static light. Most of my level gets its lighting from a directional/sky light, so i decided to put two static spot lights just above the roof, yet after a light build there is no visual effect. Maybe I need to increase the intensity of the light but i don’t want to to make it to bright. Any help and pointers would be greatly appreciated.

A few pics: