I finally found the problem and yes, it was between the keyboard and the chair. When you make changes to a data source, be sure to delete the old one from the reporting server if you have your environment set up to not overwrite the data source, this is the defalult behavior.

So to access data on another server use a user id & password, store them on the reporting server option and life is good!