SQL Server Reporting Services – Management Studio

Background

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

ScreenShot

SSMS Launch – Run as administrator

SSMS-RunAsAdministrator ( cropped )

 

Connect To Server

ConnectToServer

 

Configurable Options

ConfigurableOptions

 

Shared Schedule

New Shared Scheduled

SharedScheduled-Marketing

 

Shared Schedules

 

ObjectExplorer - SharedSchedules

Subscription – Uses Shared Scheduled

SharedScheduled-Marketing-Subscription

 

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s