<div>
You can stop the SQL Reporting server service and set it on manual start or disabled
</div>


<div>
To turn on or off the Report Server Web service by editing configuration<br />
1. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Open the RsReportServer.config file in a text editor. For more information, see Modify a Reporting Services Configuration File (RSreportserver.config, located at C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\<wbr />Reporting Services\ReportServer) in SQL Server Books Online.<br />
2. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;To turn on the Report Server Web service, set IsWebServiceEnabled to true:<br />
3. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;IsWebServiceEnabled&gt;true&lt;<wbr />/IsWebServ<wbr />iceEnabled<wbr />&gt;<br />
4. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;To turn off the Report Server Web service, set IsWebServiceEnabled to false:<br />
5. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;IsWebServiceEnabled&gt;false<wbr />&lt;/IsWebSer<wbr />viceEnable<wbr />d&gt;<br />
6. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Save your changes and then close the file.<br />
To turn on or off the Report Server Web service by using SQL Server Management Studio<br />
1. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Open SQL Server Management Studio and connect to the Reporting Services instance that you want to configure.<br />
2. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;In Object Explorer, right-click the Reporting Services node, point to Policies, and click Facets.<br />
3. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;In the Facet list, select Surface Area Configuration for Reporting Services.<br />
4. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Under Facet Properties:<br />
o &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;To turn on the Report Server Web service, set WebServiceAndHTTPAccessEna<wbr />bled to True.<br />
o &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;To turn off the Report Server Web service, set WebServiceAndHTTPAccessEna<wbr />bled to False.<br />
5. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Click OK.
</div>


<div>
<b>To stop the SSRS using Reporting Services Configuration</b><br />
On the Report Server Status page, click Stop or Start.<br />
<br />
<b>Stop SSRS using Administrative Tools</b><br />
If you are running multiple instance or if the report server is running as a named instance, verify that the instance name in parentheses corresponds to the report server instance you want to stop.<br />
<br />
<b>To stop the SSRS using SQL Server Configuration Manager</b><br />
Select SQL Server Services, right-click SQL Server Reporting Services, and click Stop or Restart.<br />
<br />
<a href="http://blogs.msdn.com/b/sqlcat/archive/2013/10/30/reporting-services-performance-and-optimization.aspx" rel="ugc">http://blogs.msdn.com/b/sqlcat/archive/2013/10/30/reporting-services-performance-and-optimization.aspx</a>
</div>


<div>
So what is best practice in case you don't need reporting services?
</div>


<div>
Please follow the url to turn report features off.
</div>


<div>
Mmh, a lot of stuff to switch off just a service...<br />
If you want to permanently switch it off, you have to set the start type to manual or disabled..<br />
If you use service manager or SQL configuration manager has the same result...<br />
So there is no &quot;best practice&quot;<br />
<br />
If you don't need the service at all, uninstall the reporting service feature, so you can even save some bytes on the disc.
</div>


<div>
<blockquote>
So what is best practice in case you don't need reporting services?
</blockquote>
Not installing it. Why did you install it if you won't need it?<br />
By the way, recommendation is to install Reporting Services in a dedicated server. Same recommendation for SQL Server Engine. The main reason is to avoid issues like you're having now (share the same computer resources).
</div>


<div>
<i>&gt;&gt;Not installing it..</i><br />
<br />
I see :) Since it's now installed, do you agree with HuaMinChen?
</div>


<div>
<i>&gt;&gt; Don't forget to set it to manual service so it won't start automatically..</i><br />
<br />
Why not disabled?
</div>


<div>
<blockquote>
Why not disabled? 
</blockquote>
Whatever the option is but not automatic.
</div>


<div>
You can choose Automatic, Manual or Disabled. Are we sure SQL Server never needs Reporting Services when no application is using it?<br />
In other words, is it safe to disable it completely?
</div>


<div>
If you put it on manual, it will not start during reboot. But it can be started if any other service forces the Reporting Service to start.<br />
If you disable it, it will not start, even another service tries to force a start. <br />
<br />
Reporting services is a tool to visualize reports crated there via a Web Browser. <br />
SQL (by default) doesn't need nor use Reporting Services, the Reporting services are usually used by applications, which also store there data in a SQL Server database. <br />
<br />
So, if you stop the service (and set it to manual or disabled) you can observe the server, if you get SQL Reporting Services related errors. This way you may even find out, it there are any other applications, which make use of reporting services. <br />
<br />
Nothing will explode, in the worst case you see some event log messages and maybe error messages in other applications. &nbsp;<br />
<br />
You can also open the Reporting Services web site so see, if there are any reports there. If not, you can assume, that it is not used.
</div>


<div>
<div class="content wysiwyg-content">
I've got me a computer with SQL 2012.. Reporting Services is eating away all the RAM. As far as I know, no application is using reporting services. Can I turn it off / disable it?<br />
If so, how?
</div>
</div>


I've got me a computer with SQL 2012.. Reporting Services is eating away all the RAM. As far as I know, no application is using reporting services. Can I turn it off / disable it?
If so, how?

SQL 2012 Reporting Services, high memory consumption - turn it off?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Windows Server 2012 is the server version of Windows 8 and the successor to Windows Server 2008 R2. Windows Server 2012 is the first version of Windows Server to have no support for Itanium-based computers since Windows NT 4.0. Windows Server 2012, now in its second release (Windows Server 2012 Release 2) includes Foundation, Essentials, Standard and Datacenter, and does not support IA-32 or IA-64 processors.

Windows Server 2012

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.