Sometimes you’ll want to manage reporting services functionality through SQL Server Management Studio (SSMS). This would be the case if you want to manage Jobs (subscriptions), Security or Shared Schedules. To connect to your reporting services instance, fire up SSMS and then choose Reporting Services as the Server type as shown in figure 1.

Figure 1: Connecting to a Reporting Services Instance

Then enter the url to your Report Server as shown above, verify the authentication method (in my case Windows Authentication) and hit Connect. If you already have SSMS running, you could click on the Connect button in the Object explorer and select Reporting Services as shown in figure 2. You will then be prompted for the same details as shown in figure 1 above.

Figure 2: Using Object Explorer – Connect Button

And that’s all there is to it! Now you can manage various aspects to your Report Server, directly in SQL Server Management Studio as shown in figure 3 below.

Figure 3: Report Server Management Options

 Until next time, “keep your ear to the grindstone” – Good Will Hunting

Brian K. McDonald, MCDBA, MCSD
Business Intelligence Consultant – Pragmatic Works Consulting

Email: bmcdonald@pragmaticworks.com | Blog: BI Developer Network

Convert with DTS xChange  | Develop with BI xPress  | Process with TaskFactory | Document with BI Documenter