I want to integrate Reports with SharePoint site. Can I install Share point and Sql Server on both machine? Which version of Share point is needed for SqlServer 2008? Will it work on same machine? can anybody done this type of stuff?

Hi, It is possible to install SQL Server and SharePoint on the same machine. The version of the SharePoint to be installed depends on the specific version of your SQL Server 2008. Please refer to the table below: Report Server Add-in SharePoint Supported SQL Server 2008 R2 SQL Server 2008 R2 SharePoint 2010 Products Y SQL Server 2008 R2 SQL Server 2008 SP2 (*) SharePoint 2007 Products Y SQL Server 2008 SP1 Cumulative Update #8 SQL Server 2008 R2 SharePoint 2010 Products Y SQL Server 2008 SQL Server 2008 SharePoint 2010 Products N SQL Server 2008 SQL Server 2008 SharePoint 2007 Products Y SQL Server 2005 SP2 SQL Server 2005 SharePoint 2007 Products Y Since SharePoint 2010 support was added in the SQL Server 2008 Cumulative Update #8 (CU8). This SharePoint 2010 support is also part of SQL Server 2008 SP2. For more information about Planning for SharePoint Integration, please refer to the link below: http://msdn.microsoft.com/en-us/library/bb326405(v=SQL.100).aspx Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help