Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

Image 1

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

Using SSMS 1

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

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

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.