July 20, 2018 at 10:20 am
Hi, I have run into this problem before and I really can't remember how I solved it. I installed SQL Server on the machine and I added my domain account when I was doing the installations to have permissions to all the components. I have ran the reporting services configuration manager and its using my domain service account to start up with. So, I am unable to access the Report Server with my account cause no permissions have been set up on the URL yet. I know it is associating the permissions with the service account but the way our configurations are, I don't know what the password is to the service account cause we aren't supposed to be using it for actual logging in.
So, how do I get Reporting Services to let me in? I don't want to change the start up account to my domain account which I believe would solve the issue cause I really do want it to use the service account. I just need to get into the site for the first time so I can assign permissions out.
I was able to get the http://servername/ReportServer link to let me in ... it asked me for credentials and then showed me the screen that has Microsoft SQL Server Reporting Services Version 12.0.5589.7
But the http://servername/Reports URL just gives me a 500 error.
July 20, 2018 at 11:34 am
amy26 - Friday, July 20, 2018 10:20 AMHi, I have run into this problem before and I really can't remember how I solved it. I installed SQL Server on the machine and I added my domain account when I was doing the installations to have permissions to all the components. I have ran the reporting services configuration manager and its using my domain service account to start up with. So, I am unable to access the Report Server with my account cause no permissions have been set up on the URL yet. I know it is associating the permissions with the service account but the way our configurations are, I don't know what the password is to the service account cause we aren't supposed to be using it for actual logging in.
So, how do I get Reporting Services to let me in? I don't want to change the start up account to my domain account which I believe would solve the issue cause I really do want it to use the service account. I just need to get into the site for the first time so I can assign permissions out.I was able to get the http://servername/ReportServer link to let me in ... it asked me for credentials and then showed me the screen that has Microsoft SQL Server Reporting Services Version 12.0.5589.7
But the http://servername/Reports URL just gives me a 500 error.
Try right clicking on your browser and Run As Administrator.
If you still have problems, check the Reporting Services log for more details on the error. There could be errors in the Windows Application event log.
Sue
July 20, 2018 at 12:05 pm
Already running as admin and nothing was in the error logs... 🙁
July 20, 2018 at 1:22 pm
Ok I think I figured it out... I think it is restricting the site cause its not HTTPS .... how do I make the report server HTTPS? 🙁
July 20, 2018 at 1:42 pm
amy26 - Friday, July 20, 2018 1:22 PMOk I think I figured it out... I think it is restricting the site cause its not HTTPS .... how do I make the report server HTTPS? 🙁
It's not that bad, more of a pain if you also have IIS on the server. Follow the instructions in the documentation - there are links to other info in case you are unfortunate enough to have this on a server with IIS:
Configure SSL Connections on a Native Mode Report Server
Sue
July 20, 2018 at 1:54 pm
Ok that didn't solve it... I was able to create an SSL URL with the server certificate we already have on the server. I don't have IIS installed on the server.
I checked the windows application logs... first it said that the URLRoot in rsreportserver.config was not right and it was using default value instead. I went in there and put the URL in the URLRoot tag... now I'm getting an error that says Failed to unload app domain DefaultDomain.
July 20, 2018 at 2:57 pm
Ok, so I fixed the errors... it had to do with FIPS encryption and I was able to update the web.config file to resolve that. So, yay, the URL at least functions.
However, I still can't get in. It keeps saying I do not have required permissions. I've tried with my domain account as well as the account it is starting up with.... what gives. :/
July 20, 2018 at 3:00 pm
Ok, I figured that out too... just had to run IE as administrator...
Well, I solved my own thread today... guess I'm smarter than I think I am. 🙂 And I did a lot of talking to myself in this thread...thank you to Sue for trying to help me as well. 🙂
July 20, 2018 at 3:59 pm
amy26 - Friday, July 20, 2018 3:00 PMOk, I figured that out too... just had to run IE as administrator...Well, I solved my own thread today... guess I'm smarter than I think I am. 🙂 And I did a lot of talking to myself in this thread...thank you to Sue for trying to help me as well. 🙂
Did you read my first reply? It was:
Try right clicking on your browser and Run As Administrator.
Sue
July 20, 2018 at 4:42 pm
Yes, but that didn’t work for me with the errors I was first getting when you said that. I just goofed and forgot to do that at the end after I fixed all that encryption stuff.
July 20, 2018 at 4:49 pm
amy26 - Friday, July 20, 2018 4:42 PMYes, but that didn’t work for me with the errors I was first getting when you said that. I just goofed and forgot to do that at the end after I fixed all that encryption stuff.
Those other errors would be in the Reporting Services logs....search on FIPS. It's something like Not part of windows platform FIPS.
At least it's Friday. 🙂
Sue
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply