{"id":334,"date":"2019-02-19T16:39:32","date_gmt":"2019-02-19T16:39:32","guid":{"rendered":"http:\/\/jackofalltradesmasterofsome.com\/blog\/?p=334"},"modified":"2023-02-28T14:49:45","modified_gmt":"2023-02-28T14:49:45","slug":"configure-basic-ssrs-and-set-up-firewall-rules-to-access-ssrs-remotely","status":"publish","type":"post","link":"https:\/\/jackofalltradesmasterofsome.com\/blog\/2019\/02\/19\/configure-basic-ssrs-and-set-up-firewall-rules-to-access-ssrs-remotely\/","title":{"rendered":"Configure basic SSRS (SQL Server Reporting Services) and Set up Firewall Rules"},"content":{"rendered":"\n

Learn how to Configure basic SSRS (SQL Server Reporting Services) and Set up Firewall Rules so you can access SSRS remotely.<\/p>\n\n\n\n

Side Note: Want to learn SQL <\/a>or Python <\/a>for free. In less then 10 minutes a day and less than an hour total? Signup for my free classes delivered daily right to your email inbox for free! <\/em><\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n

Now back to the article…<\/p>\n\n\n\n

Setting up SSRS<\/strong><\/p>\n\n\n\n

  1. Web Service URL
    1. Just select apply at the bottom right to accept defaults. The URLs link should become blue and active once complete.<\/li><\/ol><\/li><\/ol>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      • Database
        • Select \u201cChange Database\u201d and point it to the local SQL Server. Select Configure a new Server, accept all defaults and finish the wizard.<\/li><\/ul><\/li><\/ul>\n\n\n\n
          \"\"

          <\/figcaption><\/figure>\n\n\n\n
          \"\"<\/figure>\n\n\n\n
          • <\/li>
          • Web Portal URL
            • Click Apply to accept defaults. The URLs link should become blue and active once complete.<\/li><\/ul><\/li><\/ul>\n\n\n\n
              \"\"<\/figure>\n\n\n\n

              Setting up the Firewall<\/strong><\/p>\n\n\n\n

              1. Navigate to servers Firewall manager and create a new inbound rule.<\/li><\/ol>\n\n\n\n
                \"\"<\/figure>\n\n\n\n
                • Set a rule for the port, in this case it was Port 80.<\/li><\/ul>\n\n\n\n
                  \"\"<\/figure>\n\n\n\n
                  • Accept defaults but set rule to only apply to Domain accounts.<\/li><\/ul>\n\n\n\n
                    \"\"<\/figure>\n\n\n\n
                    • Name the role \u201cSSRS\u201d<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"

                      Learn how to Configure basic SSRS (SQL Server Reporting Services) and Set up Firewall Rules so you can access SSRS remotely. Side Note: Want to learn SQL or Python for free. In less then 10 minutes a day and less than an hour total? Signup for my free classes delivered daily right to your email […]<\/p>\n","protected":false},"author":1,"featured_media":135,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,5,11],"tags":[],"class_list":["post-334","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","category-consulting","category-data-warehouse"],"_links":{"self":[{"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/posts\/334","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/comments?post=334"}],"version-history":[{"count":4,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/posts\/334\/revisions"}],"predecessor-version":[{"id":1312,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/posts\/334\/revisions\/1312"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/media\/135"}],"wp:attachment":[{"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/media?parent=334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/categories?post=334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jackofalltradesmasterofsome.com\/blog\/wp-json\/wp\/v2\/tags?post=334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}