Make sure that if you are using "credentials stored securely in the report server option" that you have the "use as windows credentials when connecting to the source" checked.