I just installed SQL Server 2014 Reporting Services on my personal development computer and, after configuring it, I went to Report Manager by launching IE and going to http://localhost/Reports. The browser prompted me to authenticate, which I did, and got an error message saying I don't have the required access rights.
This is what I had to do to grant myself (an administrator) rights to use Report Manager in sixteen easy steps.
1. Enable the built-in administrator account
Run CMD as administrator and enter "NET USER administrator /active:yes"
2. Pray you remember the administrator password
3. Switch user to the administrator
4. Start IE as administrator and go to "localhost/Reports"
5. Click on Site Settings in the top right corner
6. Click on Security in the left column
7. Click [New Role Assignment]
8. Type my domain\user name and check all the checkboxes
9 . Click [OK]
10. Click on Home in the top right corner
11. Click [Folder Settings]
12. Click [New Role Assignment]
13. Type my domain\user name and check all the checkboxes
14. Click [OK]
15. Close the browser and switch back to my user
16. Prevent IE from re-authenticating when you go to Report Manager
Tools -> Internet Options -> Security -> Local Intranet -> Sites -> Advanced
Add http://localhost to the list of Intranet sites
Sometimes I find myself becoming confrontational with my users when I think they're being lazy or unreasonable. When I feel this coming on - I really must say to myself "Don't be Microsoft!"
No comments:
Post a Comment