Actual execution plan would have helped a lot, but here is my shot in the dark.

Spatial indexes work automatically only in enterprise and development editions, so if you have standard you need to use hint.

Second guess is that bounding box of spatial index is incorrect.

If those two are fine. Please post execution plan and some sample data.