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

96 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. Do you mind if I quote a few of your posts as long as I
    provide credit and sources back to your website?
    My blog site is in the very same niche as yours and my visitors would truly benefit from a lot of the information you provide here.

    Please let me know if this alright with you. Thanks!

  28. Your style is very unique in comparison to other people I have
    read stuff from. I appreciate you for posting when you have
    the opportunity, Guess I will just book mark this
    blog.

  29. Hey there I am so happy I found your webpage, I really found you by accident, while I
    was researching on Digg for something else, Nonetheless I am here
    now and would just like to say thank you for a remarkable post and a all round thrilling blog (I also love the theme/design),
    I don’t have time to look over it all at the moment but I have saved it and also added your RSS feeds, so when I have time I will be back to read much more, Please do keep up the excellent job.

  30. Having read this I thought it was extremely enlightening.

    I appreciate you finding the time and effort to put this content together.

    I once again find myself personally spending a significant amount of time both reading and leaving comments.
    But so what, it was still worthwhile!

  31. I’ve been browsing online more than three hours today,
    yet I never found any interesting article like yours.
    It’s pretty worth enough for me. In my opinion, if all web owners and bloggers
    made good content as you did, the net will be much more
    useful than ever before.

  32. Wonderful blog! I found it while browsing on Yahoo News. Do you have any tips on how to get listed in Yahoo
    News? I’ve been trying for a while but I never seem to get there!
    Many thanks

  33. Hmm it seems like your blog ate my first comment (it was super long) so I guess I’ll just
    sum it up what I had written and say, I’m thoroughly enjoying your blog.
    I too am an aspiring blog blogger but I’m still new to
    everything. Do you have any tips for inexperienced blog writers?
    I’d definitely appreciate it.

  34. I think this is among the most important information for me.

    And i am glad reading your article. But want to remark on few general things, The web site style is perfect, the
    articles is really nice : D. Good job, cheers

  35. This article offers clear idea for the new visitors
    of blogging, that really how to do blogging and site-building.

  36. I would like to thank you for the efforts you’ve
    put in writing this site. I really hope to view the same high-grade blog posts from you in the future as well.
    In fact, your creative writing abilities has inspired me to get my
    own site now 😉

  37. I read this paragraph completely concerning the difference of most up-to-date and preceding technologies,
    it’s awesome article.

  38. I think that what you said was very reasonable. But, what about this?
    suppose you were to create a killer headline?
    I ain’t saying your content isn’t good, however suppose you
    added a post title to possibly grab a person’s attention? I mean How To Setup Report Server Configuration Manager For SQL Server Reporting Services (SSRS) – Rijwan & Satya’s Blog is kinda plain. You should look at Yahoo’s front
    page and watch how they create news titles to
    get people to open the links. You might try adding a video or a related pic or two to grab
    readers interested about everything’ve got to say.
    Just my opinion, it could make your website a little livelier.

  39. Hello! I could have sworn I’ve been to this web
    site before but after browsing through a few of the articles
    I realized it’s new to me. Anyhow, I’m definitely happy I found it
    and I’ll be book-marking it and checking back frequently!

  40. Hello there! This is my first visit to your blog! We are a
    collection of volunteers and starting a new project
    in a community in the same niche. Your blog provided us beneficial information to work on. You have done a
    marvellous job!

  41. Thanks for finally writing about > How To Setup Report Server Configuration Manager For SQL Server Reporting
    Services (SSRS) – Rijwan & Satya’s Blog < Loved it!

  42. Hey there! I just wanted to ask if you ever have any issues
    with hackers? My last blog (wordpress) was hacked and I ended up losing many months of hard work due to
    no back up. Do you have any solutions to protect against
    hackers?

  43. This site was… how do I say it? Relevant!!
    Finally I have found something that helped
    me. Thanks a lot!

  44. Hey, I think your blog might be having browser compatibility
    issues. When I look at your website in Safari,
    it looks fine but when opening in Internet Explorer, it has some overlapping.

    I just wanted to give you a quick heads up! Other then that,
    terrific blog!

  45. Hey! I just wanted to ask if you ever have any problems with hackers?

    My last blog (wordpress) was hacked and I ended up losing many months
    of hard work due to no backup. Do you have any methods
    to protect against hackers?

  46. I’m really impressed together with your writing abilities and also with the structure to your blog.
    Is this a paid theme or did you modify it yourself? Anyway stay
    up the nice high quality writing, it is rare to peer a nice weblog like this
    one nowadays..

  47. 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 later. All the best

  48. Hello this is somewhat of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually code with HTML.

    I’m starting a blog soon but have no coding experience so I wanted to get advice from someone
    with experience. Any help would be enormously appreciated!

  49. I absolutely love your website.. Very nice colors & theme.
    Did you develop this website yourself? Please reply back as I’m attempting to create
    my own site and want to learn where you got this from or what
    the theme is called. Kudos!

  50. I’m amazed, I must say. Rarely do I come across a
    blog that’s equally educative and interesting, and let me tell you, you’ve hit the
    nail on the head. The issue is something that too few people are speaking
    intelligently about. I am very happy I came across this during my search for
    something regarding this.

  51. 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

  52. 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!

  53. 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!

  54. 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!

  55. Its like you read my mind! You seem to know so much about this,
    like you wrote the book in it or something.

    I think that you could do with some pics to drive the message home a bit,
    but other than that, this is wonderful blog. A great read.

    I will definitely be back.

  56. I do accept as true with all the ideas you have presented to
    your post. They’re really convincing and can definitely work.
    Still, the posts are too quick for beginners.
    May just you please prolong them a little from subsequent time?
    Thanks for the post.

  57. 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.

  58. 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.

  59. Wonderful blog! I found it while searching
    on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News?

    I’ve been trying for a while but I never seem to get there!
    Thank you

  60. 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?

  61. I got this web site from my buddy who told me concerning this site and now
    this time I am visiting this web site and reading very informative posts at this place.

  62. Thank you for any other informative web site. The place else could I get that kind
    of info written in such a perfect method? I have a venture that I’m simply now running on, and I have been on the look out
    for such info.

  63. 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.