Well you can either alter browser's settings, as I wrote previously, so that the username/password are passed automatically or you can lower security settings on the server so that anonymous users are allowed, then everyone would be able to run all reports. You can't have Windows security with no way of passing the user's credentials.
--
Joe (
Microsoft MVP - XML)