BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by David Wakefield on 18 June 2018
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Problems with Reporting Services and Windows 10 upgrade
This blog is probably only important to you if you develop using Reporting Services (SSRS) and you publish reports to a server on your development machine (usually for testing). If this is not the case for you it is unlikely to be useful.
We had the problem with SQL Server 2016; we don't know if it effects other versions.
We upgraded our laptops to Windows 10 build 1803 If you haven't done this yet, then expect it in Windows Updates any time soon! We noticed that the next time we used the Reporting Services web portal on an upgraded laptop, it returned a 503 error:
The SSRS web portal give a 503 error (5xx are internal server errors). This one is less cryptic than most!
The reason for the error message was that the service on the machine was not running. If we attempted to start it, it stopped immediately:
This SSRS service is not running!
The wrong solution
Changing the logon that the service used rectified the problem on some machines (but not all) and also potentially reduced security:
Unless you know what you are doing you would be best advised leaving this as the default user.
The right solution
Just install the SQL service packs and cumulative updates. Restart the machine and everything works fine:
Reporting Services Web Portal working fine!