For future information…
Should you receive the following error message:
the data retrieval service encountered an error during connection to the data source.
Check the firewall on the server. If it is not allowing traffic both ways on TCP port 1433, add rules to let it do that. Oh, and Windows Authentication didn’t work for me.
I’ve just wasted an entire bloody day on this problem so you don’t have to.