Sharepoint Designer 2010 / SQL Server Data Connection

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 Replies to “Sharepoint Designer 2010 / SQL Server Data Connection”

  1. 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!

Leave a Reply

Your email address will not be published. Required fields are marked *