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"
The error is occurring as you're trying to install against SQL Server Express - from MSDN:
SharePoint integrated mode is not supported
You'll need to use a non-Express edition, i.e. Standard, Enterprise, etc.