3

IS SharePoint 2007 compatible with SQL 2008 SP3? I didnt find any know issues with this combination and or a support document which says it is compatible.

https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/supported-combinations-of-sharepoint-and-reporting-services-server

4

Yes, SharePoint 2007 is compatible with SQL Server 2008 Service Pack 3.

As your link covered the "Supported Combinations of SharePoint and Reporting Services Components", I'm assuming you are after these features. So, for the Reporting Services, you need to have this additional Add-in installed: Microsoft SQL Server 2008 SP3 Reporting Services Add-in for Microsoft SharePoint Technologies

  • We are upgrading the Windows server from 2008 to 2012, and only SQL Server 2008 SP3 is compatible with it and not SQL Server SP2. Unable to find a related literature for this combination ( SharePoint 2007, SQL Server 2008 SP3, Windows Server 2012). Thanks for your suggestions. – Achiever SP Jun 12 '17 at 15:25
  • @AchieverSP I'd advice to ask only one thing per question, but briefly about that: it depends where you are installing Windows Server 2012. SharePoint 2007 can't be installed on Windows Server 2012. SQL Server 2008 SP3 can be installed on Windows Server 2012 (source). You can use SP 2017 with an SQL Server 2008 SP 3 hosted on Windows Server 2012. – moe Jun 12 '17 at 16:07
  • Yes but just want to be sure that any patch version of SP 2007 or does it need SP 2007 SP3 to connect SQL Server 2008 SP3 ? – Achiever SP Jun 12 '17 at 16:34
  • @AchieverSP I think Benny Skogberg has already answered that question above. See habaneroconsulting.com/insights/… - this suggests SP1 is the minimum. – moe Jun 12 '17 at 16:43
6

Yes, It's compatible. Just make sure you use MOSS SharePoint Service Pack 3, and you should be just fine.

Also there's no difference to SharePoint concern whether you use SP2 or SP3 on the SQL Server. In general SHarePoint installations work with one version up and down of the current minimum requirements. As SharePoint 2007 minimum requirements are SQL Server 2005, all versions of SQL Server 2008 (including R2) works properly.

Reference: MOSS 2007 SP3 with SQL Server 2008 R2

  • Doesn't the reference actually contain SQL Server 2008 R2 SP2 related discussion, not SP3? – moe Jun 12 '17 at 10:39
  • 1
    @moe True, but there are no difference when it comes to SharePoint 2007 whether or not you use SP2 or SP3. Maybe I was a bit sloppy not explaining that :-/ – Benny Skogberg Jun 12 '17 at 10:59
  • 1
    That supplements the answer well. It's good to be added! – moe Jun 12 '17 at 11:01
  • If it is not MOSS SharePoint Service Pack 3, will that be any problem? i mean lower patch version of SP 2007 doesnt work with SQL 2008 SP3? – Achiever SP Jun 12 '17 at 15:29
  • @AchieverSP Sure. To install SP3, you first need vanilla, SP1 and SP2. So it will work ;) – Benny Skogberg Jun 12 '17 at 15:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.