Manage Reporting Services using SSMS

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

I hope that you have enjoyed this post. If you did, please take just a moment to rate it below! Also, if you don’t already, please be sure to follow me on twitter at @briankmcdonald. Also note that you can subscribe to an RSS feed of my blogs.

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

Email: bmcdonald@pragmaticworks.com | Blogs: SQLBIGeek | SQLServerCentral | BIDN

Twitter: @briankmcdonald | LinkedIn: http://tinyurl.com/BrianKMcDonald