SharePoint (and Project Server) Shenanigans

Just come back after the New Year and was posed with an interesting problem.

SharePoint 2010, SSRS in integration mode but under the manage subscriptions link within a report, the Add Data Driven Subscription button was missing from the screen.

So after some googling / binging around, I found that the answer was because we were using SQL Server 2008 Standard and Data Driver Subscriptions require the Enterprise version of SQL Server.

Anyway, just a quick post in case I forget in future.  Useful links below:

• SSRS Feature Support – Integration Mode: http://msdn.microsoft.com/en-us/library/bb326290(v=sql.100).aspx
• How to use Data Driven Subscriptions within SharePoint: http://blogs.devhorizon.com/reza/2008/10/26/ssrsdata-driven-subscriptions-in-integrated-mode-part-1/
• Required versions for Data Driven Subscription support: http://msdn.microsoft.com/en-us/library/ms159150(v=sql.100).aspx

Although in this scenario I am talking about SQL Server 2008, the same is true of SQL Server 2008 R2.  In SQL Server 2012, Enterprise or Business Intelligence editions are required:

• http://technet.microsoft.com/library/cc645993(SQL.110).aspx