That's pretty weird...

For consistency I would log into Management Studio with the same user that Reporting Services use (unless you are already using Windows Authentication).

The only other alternative I can think of is to create a stored proc and call that rather than running the native query through Reporting Services.

Hope this helps...