Tuesday 11 October 2016

SQL Server : How to Change Service Account of SSRS

Change Service Account for SSRS 2012 (SQL Server Reporting Services)



To view and reconfigure service account information, always use the Reporting Services Configuration Manager. Service identity information is stored internally in multiple locations. Using the tool ensures that all references are updated accordingly whenever you change the account or password. The Reporting Services Configuration Manager performs the following additional steps to ensure the report server remains available:

- Automatically adds the new account to the report server group created on the local computer. This group is specified in the access control lists (ACLs) that secure Reporting Services files.
- Automatically updates the login permissions on the SQL Server Database Engine instance used to host the report server database. The new account will be added to the RSExecRole.
- Automatically updates the encryption key to include the profile information of the new account.

Note: If the report server is part of the scale-out deployment, only the report server that you are updating is affected. The encryption keys for other report servers in the deployment are unaffected by the service account change.

Steps to change the account



1. Open the Reporting Services Configuration Manager form Start à Programs
2. Navigate to the Service Account tab and choose one of the available system accounts, or provide a domain account as the new service account and click Apply


3. It will prompt you to backup the Encryption Key. Specify a location to store the Encryption Key file and provide the password and click OK


4. You will get a prompt to choose the administrator account for granting access rights to the new service account. Enter the account and click OK


5. The service account will now be changed to the new account and the list of activities done during the account change will be displayed on the Results window



For more info refer this Article

15 comments:

  1. Hello, I enjoy reading through your post. I like to write a little comment to support you.

    ReplyDelete
  2. I'm amazed, I must say. Rarely do I come across a blog that's both equally
    educative and entertaining, and let me tell you, you've hit the nail on the
    head. The problem is something too few folks are speaking intelligently about.
    Now i'm very happy I found this during my search for something concerning this.

    ReplyDelete
  3. I'm not sure wһere you're gettіng your informɑtion, but great topic.
    I needѕ to spend somе time learning much more or understɑnding more.
    Thanks for fantastic info I was looking for this information for my
    mission.
    Extra resources : Hoѡ Ꭲo Password Prоtect Folder With Minimum Effort And Still Leave People Amazed

    ReplyDelete
  4. I truly lovе your site.. Very nice coⅼors & theme.
    Did you create this website yourself? Please reply back as I'm wanting to
    cгeate my own website аnd would love to know ᴡhere you got this from or what the theme is called.
    Thank you!
    see it here : The Single Best Strategу To Use For Encryptіon Software Revealеd & Four
    Even Better Ways To Hⲟw To Encrypt А Passᴡord
    Fօr Free Without Questioning Yourself

    ReplyDelete
  5. Every ԝeekend i used to pay a quick vіsit this web page, as i want enjoyment, as this this web site
    conations really nice funny material too.
    сheck my source : How To Lock Files

    ReplyDelete
  6. What's up everyone, it's my first go to see
    at this site, and post is really fruitful in favor of
    me, keep up posting these posts.

    ReplyDelete
  7. The other day, while I was at work, my sister stole my apple ipad
    and tested to see if it can survive a twenty five foot drop, just so she can be a
    youtube sensation. My apple ipad is now destroyed and she has 83 views.
    I know this is totally off topic but I had to share it with someone!

    ReplyDelete
  8. I feel satisfied to read your blog, you have been delivering a useful & unique information to our vision even you have explained the concept as deep clean without having any uncertainty, keep blogging. SQL server dba Online Training

    ReplyDelete
  9. The reaѕon being beⅽause professiknal money, is
    looking for the cheapest possible levels to amass moobs beore they mark it up and
    then sell on it back tto you. If you truly wօuld like tto know
    proen secrets not only inside the trading currencү
    busineess but ɡenerally in whateᴠer project or endeavοr, you'll find just ɑ couple of quite sіmple facts.

    Ꮯhinese reqᥙirement for commodіties maay be growing and growing that entire timе, and Australia is att a pеrfеct destіnation to employ
    this growing demand.

    ReplyDelete
  10. Hi, I do think this is an excellent website. I stumbledupon it ;) I am going to return yet again since i have book marked it.
    Money and freedom is the greatest way to change, may you be rich and continue to guide others.

    ReplyDelete
  11. Hello, i believe that i noticed you visited my blog thus i got here
    to return the prefer?.I'm trying to in finding issues to enhance my site!I assume
    its adequate to use some of your ideas!!

    ReplyDelete
  12. Attractive section of content. I just stumbled upon your site and
    in accession capital to assert that I get actually enjoyed account your blog posts.

    Any way I will be subscribing to your feeds and even I
    achievement you access consistently fast.

    ReplyDelete
  13. I think this is among the most vital information for me.
    And i am glad reading your article. But should remark on some general things,
    The site style is ideal, the articles is really great :
    D. Good job, cheers

    ReplyDelete
  14. Hey there just wanted to give you a quick heads up
    and let you know a few of the images aren't loading correctly.
    I'm not sure why but I think its a linking issue.
    I've tried it in two different browsers and both show the same results.

    ReplyDelete
  15. Hi there to every body, it's my first pay a quick visit of
    this weblog; this web site contains amazing and truly good data
    designed for readers.

    ReplyDelete