SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Getting SSRS 2016 installed properly (so all the pieces work)


Getting SSRS 2016 installed properly (so all the pieces work)

Author
Message
pietlinden
pietlinden
SSC-Dedicated
SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)

Group: General Forum Members
Points: 34051 Visits: 15491
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
RandomStream
RandomStream
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1217 Visits: 590
pietlinden - Wednesday, January 31, 2018 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

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?
Sue_H
Sue_H
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: General Forum Members
Points: 35814 Visits: 10231
pietlinden - Wednesday, January 31, 2018 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


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



pietlinden
pietlinden
SSC-Dedicated
SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)

Group: General Forum Members
Points: 34051 Visits: 15491
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
Sue_H
Sue_H
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: General Forum Members
Points: 35814 Visits: 10231
pietlinden - Thursday, February 1, 2018 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


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



pietlinden
pietlinden
SSC-Dedicated
SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)

Group: General Forum Members
Points: 34051 Visits: 15491
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.
Sue_H
Sue_H
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: General Forum Members
Points: 35814 Visits: 10231
pietlinden - Thursday, February 1, 2018 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.


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



Sue_H
Sue_H
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: General Forum Members
Points: 35814 Visits: 10231


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



pietlinden
pietlinden
SSC-Dedicated
SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)

Group: General Forum Members
Points: 34051 Visits: 15491
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.)
Sue_H
Sue_H
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: General Forum Members
Points: 35814 Visits: 10231
pietlinden - Thursday, February 1, 2018 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.)


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



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search