Service Account: In this tab, we can configure Report Server Windows service account. In the main tab of configuration manager, we can start and stop Report Server service and at the same time we can find out Report Server edition, product version and other main information about SQL Server Reporting Service. We can find and run the Report Server Configuration Manager on the Windows start screen.Ĭlick Report Server Configuration Manager.
We can find the below settings in Report Server Configuration Manager: With the Report Server Configuration Manager, we can change and customize various parameters of the SQL Server Reporting Service. This tool helps us to customize SQL Server Reporting Service parameters and configurations. SQL Server Reporting Service provides a tool that is named as such Report Server Configuration Manager. On this page, ensure that the Virtual Directory parameter is set correctly, and that the URL is valid.Ĭlick Exit to close the RS Configuration Manager.After the native installation of the SQL Server Reporting Service, we may need to customize some settings of Report Server. In the Reporting Services Configuration Manager left pane, select Report Manager URL. If not, click the Change Database button and complete the Report Server Database Configuration wizard. On this page, ensure that the SQL Server Name and Database Name fields contain correct values. In the Reporting Services Configuration Manager left pane, select Database. 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. In the RS Configuration Manager left pane, select Web Service In the RS Configuration Connection dialog, make sure that your local report server instance (for example SQLExpess) is selected and click Connect. Navigate to Start -> All Programs -> Microsoft SQL Server 2012 -> Configuration Tools -> Reporting Services Configuration Manager. Note: You must be logged in as a member of the local administrators group on the computer where SQL Server 2012 Express is installed. Then run the installation package and follow instruction until you get feature selection page.įollow rest of the steps and complete the installation. By the way, I'm on a local desktop installation with Windows 7.įollowing up on my comment, you have to select ENU\圆4\SQLEXPRADV_圆4_ENU.exe for installation. There seems to be so many files related to SQL Server 2012, and I'm not sure how that would affect Visual Studio I currently have installed. What should my next steps be to troubleshoot further? I'm tempted to uninstall and reinstall, but I'm not confident that I can uninstall properly.
exe file that includes everything available to download, including the Reporting Services.
So, in my mind, perhaps I don't have the Reporting Services installed, so I try to install the features, but there's no Reporting Services listed as an available feature to add. When I go to the SQL Server Configuration Manager, I do not see Reporting Services as a service listed to start of stop. In Reporting Services Configuration Manager, the Connect button is grayed out, and when I click on Find, I get error message of "Unable to connect to the Reporting Services." See below. Update: I've followed Kin's instructions, but just cannot advance further. Is there another installation file that includes Reporting Services, or do I actually have it now but cannot tell it's installed? I went to Control Panel -> Administrative Tools -> Services already and do not see it listed, which tells me that it's not installed? Everywhere I search for SQL Server 2012 Express with Advanced Services, I ended up with this link,, and every time I install it, I do not see where I can add reporting services as a feature.