How do you authenticate the database connection when using Reporting Services Forms authentication?
I somehow missed seeing the Credentials section you can set for a data source. This way I can use SQL Server authentication and it works.