It works now! What happened was that we were not using the SA password for the data source (as we didn't know it). We subsequently found the new SA password...

It gives a "An error has occured during report processing

Query execution failed for data set '...' ". When I use the data source in report manager after changing the connection...