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.
4 responses to “Sharepoint Designer 2010 / SQL Server Data Connection”
I even tried a fully qualified machine name, which includes the domain information. I resolved this problem by using the IP address of the machine hosting the SQL Sever 2008 R2 instance (that machine is a VM WinSvr 2008 R2) instead of the machine name.
http://www.sqlservercentral.com/Forums/Topic2300-20-1.aspx
At least you got it resolved! Thanks for letting me know this additional step.
Too bad this blog wasn’t at the very top in the google results. I went through about 10 different links and all the numerous pages of comments with no luck. Not a single response mentioned anything about firewall settings. This was the issue all along. THANK YOU!
Thanks for persevering and finding this post!