So I can try to remove the 'extra' SSRS (whichever one it is, and hopefully without breaking it), or I could remove the one I restored and start fresh with the new SSRS. I don't want to break the installation (I already did that once). None of the Google posts are about this problem. Some Googling indicates that I have too many rows in the dbo.Keys table of ReportingServices. If I have a scale-out deployment, it's an accident. The feature: 'Scale-out deployment' is not supported in this edition of Reporting Services. Now, when I try to access localhost eportserver I receive this error: Then I configured Reporting Services to use that database instead of the one that it installed by default. I restored the old one (and its tempdb) to the new server. The clean SSRS database was created with the name ReportingServices, but the old one was ReportingServices$SQLEXPRESS.

The database wasn't too big of a deal, but reporting services is proving more difficult. Then I had to move the database and reporting services from the 2014 backups to the clean 2016 database. I uninstalled SQL Server Express 2016 and installed a clean copy of SQL Server Express 2016 with Advanced Services. I finally sacrificed some of my free time to address this stand-alone server. Should I uninstall SQL Express 2016? And then what? I have database backups from the 2014 instance. I attempted the obvious-running the Advanced Services installer as an upgrade. I need to add Reporting Services to an existing installation and then upgrade the Reporting Services databases. Since Door #2 said I could 'choose what to install', that one looked like a winner.Īnyway, what do I do now? I have upgraded the SQL Server Express to 2016 but the Reporting Services are not there. The link above demonstrates that I was supposed to choose Download Media-although there is nothing in that dialog that indicates that Advanced Services were actually hiding behind Door #3. It's possible that I missed something or accidentally clicked Next, but I can't think how that happened. By the time it was clear that the the advanced features were not present in that installer, the Cancel button and the close box were grayed out and the upgrade was in process.

During the installation, I hoped that I would either be able to select Advanced or stop the installation. I couldn't find an installer specifically for the advanced version, so I downloaded and started the installer (there is only one) and chose Custom Installation. I am attempting to upgrade that system to 2016 Express with Advanced Services. The system uses Reporting Services, so it's 2014 Express with Advanced Features. I have a SQL Express 2014 installation on a stand-alone system.

Sql server 2016 express