SQL Server tables and stored procedures CAN be accessed from Sharepoint and Infopath, BUT it is not recommended to do it directly. Serious. Can’t tell you strongly enough. 

Use Web Services to query SQL Server from Sharepoint or Infopath.

Use SQL Server Reporting Services to report and showcase data in Sharepoint.

More on this later as this is a placeholder till I get the marks on this…

Tags: ,