Introduction

Microsoft SQL Server Reporting Services (SSRS) is a server-based report generating software system. SSRS is a part of a suite of Microsoft SQL Server services which consists of SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services). This means that, it comes with a SQL Server License. We can use it to prepare and deliver a variety of interactive and printable reports with less effort. It represents the RDL (Report Definition Language) component to graphic icons in a GUI (Graphical User Interface). Instead of writing code, the user can drag-and-drop graphic icons into an SSRS report format. 

This article will describe the simple steps to configure the Report Server. 

First, you need to install SQL Server Reporting Services. There are two methods to install it. 

Method 1

Install it from SQL Server installation file while installing SQL Server:

ssrs install from sql

Method 2

Another method is Download SQL Server Reporting Services separately and install it. After installation of SQL server reporting services, type Reporting server configuration manager in the windows search box and open it. Then follow the given steps below. 

Steps to Setup Report Server Configuration Manager

 Click on Connect and insert a Server Name and Select Report Server Instance as shown below, then click on Connect.

Connect
2

Then, click on Service Account. Now you have to sign up for a Report Server Service Account. Here, you have two options, use a built-in account, or use another account. If you choose a built-in account, you will get a Network Service as well as Virtual Service Account in the selection options. If you have a domain user, then you can choose to use another account option and provide a Domain\User Account and Password.


In my case, I have selected a built-in account -> Virtual Service Account. Which we can get by default selection.

3

After that, click on Webservice URL. A Report Server virtual directory will be created by default. If you have your own Report Server Web Service Site then you can use its IP Address, TCP Port, HTTPS Certificate, and HTTPS Ports for your web service URL. For me, I am choosing default values for Report Server Web Service Site identification.  Then click on Apply.

4webserviceurl

Click on Database then click on Change Database.

5.Database

After that following screen will appear. Select create a new report server database if you are creating a report server database for the first time. However, you can select choose an existing report server database if you have already installed a report service. Then click Next.

6.Databaseselection

Database Server 

Insert your Server name then select Authentication Type as SQL Server Account, Username, Password, and click Next.

7.databaseusername

Database 

Choose Report Server Database as report server and click Next.

8.database

Credential 

Select Authentication Type as SQL Server Credentials, insert username and password, then click Next.

9Credential

Summary

The following Summary will come and click on Next

10Summary

It saves the setup and completes after a few seconds. Then click on finish.

progress and finish

Click on the Web portal URL. A virtual directory and URL will be created by default.

webportalurl2

Finally, type this web portal URL in the browser. SQL Server Reporting Service will open in the browser. There you can create new report or upload any existing RDL (report file) and view the report.

SSRSinBrowser

Conclusion

In this way, the Report Server is set up successfully and now is ready to use. You can create a new report or upload any existing RDL (report file) and view the report using SQL server reporting services.

References

Wikipedia

63 thoughts on “How To Setup Report Server Configuration Manager For SQL Server Reporting Services (SSRS)”
  1. I’m not that much of a internet reader to be honest but
    your sites really nice, keep it up! I’ll go ahead and bookmark your website to
    come back in the future. All the best

  2. I got this web page from my buddy who shared with me on the topic of this site and at
    the moment this time I am browsing this website and reading
    very informative articles or reviews at this time.

    Feel free to visit my page ::

  3. Please let me know if you’re looking for a writer for your weblog.
    You have some really great articles and I believe I would be a good asset.

    If you ever want to take some of the load off, I’d absolutely love to write some
    material for your blog in exchange for a link back to mine.
    Please shoot me an email if interested. Cheers!

  4. I’m truly enjoying the design and layout of your website. It’s a very
    easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a developer to create
    your theme? Fantastic work!

  5. Greetings from California! I’m bored to tears at work so I decided to browse your site on my
    iphone during lunch break. I love the information you provide here and can’t wait to take a look when I get home.
    I’m amazed at how quick your blog loaded on my mobile ..

    I’m not even using WIFI, just 3G .. Anyhow, superb site!

  6. You are so interesting! I don’t suppose I’ve
    read through anything like that before. So good to discover another person with a
    few genuine thoughts on this subject matter. Really..
    many thanks for starting this up. This web site is something
    that is needed on the internet, someone with a bit of originality!

  7. We stumbled over here from a different web address and thought I
    may as well check things out. I like what I see so i am just following you.
    Look forward to looking at your web page for a second time.

  8. This is a very good tip especially to those new to
    the blogosphere. Short but very accurate info… Thank you for sharing this one.
    A must read post!

  9. You made some good points there. I looked on the net for more info about the issue and found most
    people will go along with your views on this web
    site.

  10. Hello! This is my first comment here so I just wanted to give a quick shout out and say
    I really enjoy reading your blog posts. Can you suggest any other blogs/websites/forums that
    go over the same subjects? Appreciate it!

  11. It’s a pity you don’t have a donate button! I’d definitely donate to
    this fantastic blog! I guess for now i’ll settle for
    book-marking and adding your RSS feed to my Google
    account. I look forward to new updates and will talk about this website with my Facebook group.

    Chat soon!

  12. Hello there! I could have sworn I’ve been to this
    blog before but after checking through some of the post I realized it’s new to me.
    Anyways, I’m definitely delighted I found it and I’ll be book-marking
    and checking back often!

  13. whoah this weblog is magnificent i really like studying your articles.
    Stay up the great work! You recognize, lots of persons
    are looking round for this information, you can aid them greatly.

  14. You actually make it seem so easy with your presentation but I
    find this matter to be really something which I think I would never understand.
    It seems too complicated and extremely broad for me.
    I’m looking forward for your next post, I will try to get the hang of it!

  15. You actually make it seem so easy with your presentation but
    I find this matter to be really something which I think I would
    never understand. It seems too complicated and very broad for me.
    I am looking forward for your next post, I will try to get the hang of it!

  16. I’m impressed, I have to admit. Seldom do I come across a blog that’s equally educative and interesting, and without a doubt, you’ve hit
    the nail on the head. The problem is an issue that not enough men and women are speaking intelligently about.

    I am very happy that I found this in my search for something regarding
    this.

  17. This is my first time go to see at here and i am in fact
    happy to read all at alone place.

  18. Everything is very open with a very clear description of the issues.

    It was definitely informative. Your website is extremely helpful.

    Thank you for sharing!

  19. I just could not depart your website before suggesting that
    I actually loved the standard information a person supply in your
    guests? Is going to be again incessantly to investigate cross-check new posts

  20. It’s going to be finish of mine day, except before finish I
    am reading this great post to increase my know-how.

  21. It’s actually a great and useful piece of information. I am glad that you simply shared
    this helpful info with us. Please stay us up to date like this.

    Thank you for sharing.

  22. Great blog! Do you have any helpful hints
    for aspiring writers? I’m hoping to start my own blog
    soon but I’m a little lost on everything. Would you suggest starting with a free platform like WordPress or go for a paid
    option? There are so many choices out there that
    I’m completely overwhelmed .. Any tips? Thanks a lot!

  23. Attractive portion of content. I just stumbled upon your site and
    in accession capital to claim that I get in fact enjoyed account your blog posts.
    Anyway I’ll be subscribing in your augment and even I achievement you get entry to
    persistently rapidly.

  24. Hmm is anyone else encountering problems with the
    images on this blog loading? I’m trying to determine if its a problem on my end or if it’s
    the blog. Any responses would be greatly appreciated.

  25. Howdy, i read your blog occasionally and i own a similar one and i was just curious if you get a lot of spam responses?
    If so how do you reduce it, any plugin or anything you can advise?
    I get so much lately it’s driving me mad so any help is very
    much appreciated.

  26. I believe that is among the most important info for me.
    And i am happy studying your article. However
    wanna statement on few normal things, The website style
    is wonderful, the articles is in point of fact nice :
    D. Just right task, cheers

  27. Hey there just wanted to give you a quick heads up.
    The text in your post seem to be running off the screen in Chrome.
    I’m not sure if this is a format issue or something to do
    with web browser compatibility but I figured I’d post to let you know.
    The layout look great though! Hope you get the problem solved soon. Thanks

  28. Excellent post however I was wanting to know if you could write
    a litte more on this topic? I’d be very thankful if
    you could elaborate a little bit further.
    Many thanks!

  29. I do not even know how I ended up right here, but I believed this post was once good.
    I don’t know who you might be but certainly you’re going to a well-known blogger when you aren’t already.
    Cheers!

  30. You actually make it seem really easy along with your presentation but I to find this matter to be
    actually something that I feel I’d by no means understand.
    It sort of feels too complex and extremely large for me.
    I am taking a look forward on your subsequent post, I’ll try to
    get the cling of it!

  31. I all the time emailed this webpage post page
    to all my friends, for the reason that if like to
    read it next my friends will too.

  32. Does your blog have a contact page? I’m having trouble locating
    it but, I’d like to send you an e-mail. I’ve got
    some recommendations for your blog you might be interested
    in hearing. Either way, great website and
    I look forward to seeing it improve over time.

  33. great points altogether, you simply won a new reader.
    What could you suggest in regards to your put up that you just made a few days in the past?
    Any positive?

  34. My partner and I stumbled over here from a different page and
    thought I might check things out. I like what I see so now i’m following you.
    Look forward to checking out your web page yet again.

Comments are closed.