in RS2000 I don't know for sure but in RS2005, you can set connection properties to your datasource to "use credentials stored securely on Report Server". You just make sure...

You need to grant permissions on the database. In your datasource, you can set the connection properties to connect using either the user's credentials (who have appropriate permissions on the...