SharePoint and SQL connections presenting no data

During development of InfoPath forms together with SharePoint 2010 some of the data connections just weren’t retrieving any data.

The catch was the SharePoint Central Administration – General Application Settings – under InfoPath Forms Services – Configure InfoPath Form Services page. There is one setting “Embedded SQL Authentication” the checkbox “Allow embedded SQL authentication” should be checked.

After correcting this problem the SQL information was fetched without any problem and the data connections where working fine.