SQL Server Express 2016 – Does It Include Configuration Manager?

Unfortunately, you cannot install SQL Express without Administrator rights on the machine and it's not something you can set in the config file or on the command line. If being able to install without Administrator rights is a requirement, you may want to investigate using SQL Server Compact Edition.

See the following MSDN topics for more information:

• Using SQL Server Compact 3.5 (Visual Studio)
• How to: Deploy a SQL Server Compact 3.5 Database with an Application
• SQL Server Compact 3.5 SP2 Books Online
• Local Data Overview
• Choosing Between SQL Server 2005 Compact Edition and SQL Server 2005 Express Edition -- A little dated now, but much of it still applies.

Following up on my comment, you have to select ENU\x64\SQLEXPRADV_x64_ENU.exe for installation.

Download link.

Then run the installation package and follow instruction until you get feature selection page.

Follow rest of the steps and complete the installation.

Now Verify the RS installation :

Note: You must be logged in as a member of the local administrators group on the computer where SQL Server 2012 Express is installed.

1. Navigate to Start -> All Programs -> Microsoft SQL Server 2012 -> Configuration Tools -> Reporting Services Configuration Manager.

2. In the RS Configuration Connection dialog, make sure that your local report server instance (for example SQLExpess) is selected and click Connect.

   

3. In the RS Configuration Manager left pane, select Web Service URL.

   

4. Make sure that the Virtual Directory parameter is set to ‘ReportServer_’ (‘ReportServer_SQLEXPRESS’ for the SQLEXPRESS instance), and that the TCP Port is set to 80. Click Apply.

5. In the Reporting Services Configuration Manager left pane, select Database.

6. On this page, ensure that the SQL Server Name and Database Name fields contain correct values. If not, click the Change Database button and complete the Report Server Database Configuration wizard.

7. In the Reporting Services Configuration Manager left pane, select Report Manager URL.

8. On this page, ensure that the Virtual Directory parameter is set correctly, and that the URL is valid.

9. Click Exit to close the RS Configuration Manager.