I experienced the same issue, and the setting above seemed to do the trick.
THe think I'm curious about is why was it that I would get error messages sporadically, and not consistently as permissions were involved. I was expecting consistent errors in initializing the component MSDAINITIALIZE. It seemed somewhat random however in that sometimes the data would retrieve and sometimes not.
Does anyone have a good explanation for the randomness?