I had a similar issue when trying to use windows integrated security. When I used credentials supplied by the user and checked the box for use as windows credentials when connecting to the data source I was able to run the reports. The user does have to enter their full domain\lanid and password but, it worked for me as long as there was a trust between the domains.