This is really a top annoying problem, the constant prompt for credentials each time you open a report. All you need to do is disable the Internet Explorer Enhanced security on the reporting server. This is done by running Add/Remove programs, Add/Remove Windows Components. In Windows 2008 you will find the setting in Computer Management, Security Information, Configure IE Esc.

Deselect the checkmark in Windows 2003 and you can start running your reports without the prompt :-)

Select Off in Windows 2008.

This post was originally posted to http://agerlund.spaces.live.com/blog/cns!3A51A2B50B5C1F51!364.entry April 1 2009