I'm using Windows 2003 server with Sql server 2005 June CTP. When I create a data-driven subscription for a report everything works fine, the query that gets the subscribers from a database is validated successfully. The subscription is time triggered, but when it should start and deliver the reports I get a logon failure error. I use credentials stored securely in the report server. I tried it with sa account and it still doesn't work. When I try to edit the subscription I can see there is blank space where the password should be, is this just to prevent abuse or because it just doesn't store the password? Could someone please tell me what am I doing wrong, thanks.
I believe the problem was that the report server didn't want to store my execution account, still not sure why...
