January 31, 2018 at 10:43 am
I'm trying to install SSRS on my laptop (Win 10, if it matters), but if I customize at all, things like the portal don't work right. I could uninstall it and reinstall using all the default options... but I'm not sure I want to do that (will if I have to!).
Is there a good tutorial on installing SSRS so that it actually works out of the box?
thanks!
Pieter
January 31, 2018 at 11:13 am
pietlinden - Wednesday, January 31, 2018 10:43 AMI'm trying to install SSRS on my laptop (Win 10, if it matters), but if I customize at all, things like the portal don't work right. I could uninstall it and reinstall using all the default options... but I'm not sure I want to do that (will if I have to!).
Is there a good tutorial on installing SSRS so that it actually works out of the box?thanks!
Pieter
By default, it listens on port 80. Which portal? There is a /reportserver (text based) and /reports. Have you tried both? Have you check log? Antivirus s/w running?
January 31, 2018 at 12:15 pm
pietlinden - Wednesday, January 31, 2018 10:43 AMI'm trying to install SSRS on my laptop (Win 10, if it matters), but if I customize at all, things like the portal don't work right. I could uninstall it and reinstall using all the default options... but I'm not sure I want to do that (will if I have to!).
Is there a good tutorial on installing SSRS so that it actually works out of the box?thanks!
Pieter
Since you already have things in place for how you want it, I'd try just restarting the service and then checking the SSRS log. If it's choking on one of the things you have configured, it usually would show up in the log when starting up. Which pieces did you customize?
Sue
February 1, 2018 at 1:29 am
Sue,
Got annoyed and uninstalled and reinstalled it. Maybe I need to learn to read the logs. Which should I look at? (Where is it?) Right now I can connect to the database(s) and create reports, but SSRS has a fit when I try to publish (so my Report Configuration file is screwy?).
When I reinstalled everything, I just accepted the defaults, and did a full install. Which log file am I looking for? Where is it? When I queried the execution logs in ReportServer database, they were empty. Clearly something's awry with where my reports are configured to publish to.
Is there a good website or whatever that will walk me through diagnosing the problem(s) I'm having?
Thanks!
Pieter
February 1, 2018 at 6:58 am
pietlinden - Thursday, February 1, 2018 1:29 AMSue,
Got annoyed and uninstalled and reinstalled it. Maybe I need to learn to read the logs. Which should I look at? (Where is it?) Right now I can connect to the database(s) and create reports, but SSRS has a fit when I try to publish (so my Report Configuration file is screwy?).When I reinstalled everything, I just accepted the defaults, and did a full install. Which log file am I looking for? Where is it? When I queried the execution logs in ReportServer database, they were empty. Clearly something's awry with where my reports are configured to publish to.
Is there a good website or whatever that will walk me through diagnosing the problem(s) I'm having?
Thanks!
Pieter
The execution log views are just going to give you the information on the execution of the reports themselves but that's about it. If you have configuration issues, permission issues and things like that, they show up in the Reporting Services log. You can also see many of SOAP API calls that are happening when you navigate through folders, reports. The reporting services logs are located at:
Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles
They are all named ReportServerService_<timestamp >
This blog goes over some of the things you can find in the SSRS log - it goes over more than just subscriptions despite the name:
Troubleshooting Subscriptions: Part II, Using the Reporting Services Trace Log File
There is another one on one of the MS blogs from the SSRS group - I'm still looking for it and will post back when I find it.
What errors are you getting on deployments and how are you doing the deployments?
Sue
February 1, 2018 at 12:56 pm
Are the recommendations/steps for configuring SSRS the same since 2008? I've seen videos on it on youtube and I could probably do that (have a 2012 book too...) It's just kinda frustrating that I don't think I've ever gotten SSRS to install completely right. Even if I have the wizard do it.
February 1, 2018 at 1:18 pm
pietlinden - Thursday, February 1, 2018 12:56 PMAre the recommendations/steps for configuring SSRS the same since 2008? I've seen videos on it on youtube and I could probably do that (have a 2012 book too...) It's just kinda frustrating that I don't think I've ever gotten SSRS to install completely right. Even if I have the wizard do it.
Yeah pretty much. I can't think of any differences really. If you install it and leave it not configured whatever that option is with not configured and then configure it through Reporting Services configuration manager you should be fine with the defaults when it's on your own laptop. A couple of the things I can think of where you could get tripped up would be on some of the pages with the defaults, you have some warning thing towards that top of the page that says whatever is not configured. Those are really just a matter of clicking the Apply button on the bottom. It's kind of like confirming you want those defaults. I think it does that on both of the URL configuration pages - web service and report manager urls. The other thing I've seen people get confused with (it's not just you) is when you get to the Database page. So on a new install where you leave it to be configured through Reporting Services Configuration Manager, on the Database page select Change Database. And then some other window will pop up and you point to the SQL Server instance where you want the ReportServer and ReportServerTemp databases installed.
And then if something wasn't set right in that process, you should get an error in the Reporting Services trace logs.
Sue
February 1, 2018 at 1:35 pm
Hey Pieter -
Take a look at this post with the screenshots to configure everything. Not sure if that helps but thought it might - you can skip that last step listed under "configuring SSRS for Microsoft Dynamcis GP"
How To Install Microsoft SQL Server 2016: Configuring SQL Server Reporting Services
Sue
Edit: wrong link
February 1, 2018 at 1:53 pm
Great, I'll check it out...
Because I let the installer configure everything, and of course the portal doesn't work right. (I can see it, but can't publish.)
February 1, 2018 at 2:26 pm
pietlinden - Thursday, February 1, 2018 1:53 PMGreat, I'll check it out...
Because I let the installer configure everything, and of course the portal doesn't work right. (I can see it, but can't publish.)
Did you add yourself as a System Administrator after it's all configured?
If not, Right click on IE, run as administrator and then go to site settings, security and add yourself as system administrator.
Sue
February 1, 2018 at 4:24 pm
I've gotten Report Builder to work, so I'm getting somewhere. When I'm more alert, I'll see if I can get SSRS properly configured. (After watching several videos on it)....
Now to figure out how to make VS work!
February 1, 2018 at 5:22 pm
pietlinden - Thursday, February 1, 2018 4:24 PMI've gotten Report Builder to work, so I'm getting somewhere. When I'm more alert, I'll see if I can get SSRS properly configured. (After watching several videos on it)....Now to figure out how to make VS work!
Sometimes we need to stop when we are ahead so that we can feel like we are getting somewhere. Even if we take two steps back tomorrow. 🙂
Sue
February 1, 2018 at 6:26 pm
I don't think I have ever gotten SSRS completely configured properly before, so I'll take it!
Gotta celebrate the victories when you get them!
The Report Builder stuff totally works. I can create report objects (data sets, connections, reports), and publish them. But I can't get VS/Data Tools to work yet. Guess I should go find an article that compares the setups of the two...
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply