October 19, 2015 at 5:37 pm
I'm on OS Wndows 8.1 on local machine and want to use it for hosting RS and SSMS.
After installing SQL Server Express 2014 with all features and default settings for Report builder I find that the Web Service URL returns blank page (See attached screenshot.). That is the url where I expect to find Report Builder environment.
Meanwhile, Report Manager URL returns the expected interface, a page to which I can upload finished SSRS reports.
I don't know a methodical way to troubleshoot this What I've tried:
I followed this video to configure Reporting Services: https://www.youtube.com/watch?v=W4jUBPL2tNM
set IE to always Run As Administrator
SSMS is already running when I start Report Server services
All SQL Services are running.
TCP/IP enabled and running.
Report Manager site has two role assignments, the Built In Admin and local user Windows account, both with all privileges (Browser, Content Manager, My Reports, Publisher, Report Builder).
Report server configured to use report server database.
The service account I am using is by default the built in account: ReportServer$SQLEXPRESS. But I've also tried using Windows Account.
Event Application Logs have one Warning "The value for UrlRoot in RSReportServer.config is not valid. The default value will be used instead."
I need ideas for getting the Web Service URL to work so I can get started building SSRS reports in 2014.
--Quote me
October 19, 2015 at 5:51 pm
It's the Report Manager interface you want, http://localhost/Reports_SQLEXPRESS
If you are not seeing the link to report builder on the report manager page, then you could try installing it directly.
http://www.microsoft.com/en-gb/download/details.aspx?id=42301
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);October 19, 2015 at 9:56 pm
Mister Magoo, Thanks. I've installed it and it looks like I'll be able to create a report now.
--Quote me
October 20, 2015 at 5:15 pm
MM, yes, you solved my issue, but just wondering ... do you know if the web service URL gets used for anything other than for connecting Report Builder to Report Server?
--Quote me
October 20, 2015 at 5:22 pm
Yes, it's used for various management tasks (for example, rs.exe uses it for command line management) and can be used in links to individual reports where the Report Manager interface is not needed/required for running the report.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply