SSRS 2008r2 installation integrated with Sharepoint

Question

I would like to install SQL Server Reporting Services 2008r2 integrated with Sharepoint. When I am installing it there is a radio box which indicates installation mode. When I choose it for integrated mode then setup gives me an error. It says that I have to try install with another SQL version except SQL advanced. But which SQL version should I install?

The Error message is "Reporting Services in SharePoint integrated mode is not supported for EXPRESS_ADVANCED edition"

Answer 1

The error is occurring as you're trying to install against SQL Server Express - from MSDN:

http://msdn.microsoft.com/en-us/library/cc281020(v=sql.105).aspx

Unsupported Features:

SharePoint integrated mode is not supported

You'll need to use a non-Express edition, i.e. Standard, Enterprise, etc.