I am getting a logon failed error on all reports I create in asp.net, except in two instances - when I attach a sample report from the book I am reading or when I connect to a local access database. If I try to connect to SQL Server on my local machine or a remote access file on a shared drive, I get this error.

My SQL Server is set up for windows only authentication. Also, I don't have any problems connecting to the data when designing the report in asp.net or if I design and run them in a windows program.

Any ideas?