SQL Server Reporting Services – Management Studio


One of the areas not often mentioned is accessing and configuring SQL Server Reporting Services ( SSRS ) through SQL Server Management Studio ( SSMS ).


SQL Server Management Studio

  1. Launch SQL Server Management Studio ( SSMS ) in administrator mode
    • Access Windows Desktop
    • From the Start menu, access SQL Server Management Studio
    • Right click on the selection, and from the drop down menu select “Run as administrator
  2. SSMS Launches and the Connect to Server Window appear
    • In the Connect To Server window
      • On the Server Type dropdown, Select “Reporting Services”
      • In the server name textbox, enter the server name
        • For a local default instance
          • Enter the name of the local machine or .
        • For a local named instance, enter “.\instance-name”
          • In our case “.\v2005MIRROR”
        • Authentication
          • Windows Authentication
            • As that is the only choice
  3. Configurable Options includes:
    • Server Properties
      • General
      • Execution
      • History
      • Logging
      • Permissions
    • Data Sources
    • Reports Folders and Individual Reports
    • Security
      • Users Roles
      • System Roles
    • Shared Schedules


SSMS Launch – Run as administrator

SSMS-RunAsAdministrator ( cropped )


Connect To Server



Configurable Options



Shared Schedule

New Shared Scheduled



Shared Schedules


ObjectExplorer - SharedSchedules

Subscription – Uses Shared Scheduled



Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s