How do you use cloud databases? Take the survey.

Estate -> Installed Versions doesn't show latest release of SQL Server 2017

Hi
I can only see CU12 for Sql Server 2017.

As my Sql Monitor installation can't get through my firewall, I need to update the versions json, which lies at C:\ProgramData\Red Gate\SQL Monitor\SqlServerVersions.json myself with a powershell script. 
So getting it from https://www.red-gate.com/products/dba/sql-monitor/assets/sql-server-versions.json gets me only CU12. 
But since 18 Dec. 2018 there is CU13 (gives build 14.0.3048.4) and since 8 Jan 2019 the hotfix 1 for CU13 (gives build 14.0.3049.1) is available. 
But these cann't be found in the json.  

Jürgen
Tagged:

Best Answer

  • Alex BAlex B Posts: 1,131 Diamond 4
    Hi @bauerju,

    After discussing with @Russell D, SQL Monitor polls gets the json from the Redgate website every 6 hours, though when specifically that is or is triggered is a bit of an unknown at the moment.

    The json itself may or may not have been updated to include the latest versions.  Having said that, I've just downloaded the json from https://www.red-gate.com/products/dba/sql-monitor/assets/sql-server-versions.json and it has CU13 included, so it would seem it's just a matter of time before this is reflected in the UI.

    Work is being done on this process, so this is subject to change, but that's how it currently sits at the moment.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?

Answers

  • Alex BAlex B Posts: 1,131 Diamond 4
    edited January 22, 2019 3:51PM
    Hi @bauerju,

    This has just been updated and should be available in the next release.  You if you are editing the file anyway, you should be able to add the following at the end of the section for version 2017 (between 2017 and 2019):
    <div>   {
    &nbsp; &nbsp; &nbsp; "Edition": "2017",</div><div>&nbsp; &nbsp; &nbsp; "ProductLevel": "RTM CU12",
    &nbsp; &nbsp; &nbsp; "Version": "14.0.3045.24",
    &nbsp; &nbsp; &nbsp; "ReleaseDate": "2018-10-25",
    &nbsp; &nbsp; &nbsp; "EndOfSupportDate": "2022-10-11",
    &nbsp; &nbsp; &nbsp; "DownloadUrl": "https://support.microsoft.com/en-us/help/4464082/cumulative-update-12-for-sql-server-2017"
    &nbsp; &nbsp; },</div>
    I hope that helps!

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • Russell DRussell D Posts: 1,324 Diamond 5
    edited January 22, 2019 3:54PM
    Just to add to Alex's comment - we do not track hotfixes on this page (see the note on this page: https://documentation.red-gate.com/sm8/versioning-and-patching), so the 8th Jan hotfix won't be on that page. You can add it manually using the json syntax above though.
    Have you visited our Help Centre?
  • bauerjubauerju Posts: 33 Bronze 3
    Hi Alex B , Hi Russell D
    I just installed the new release ( 8.0.26.19750 ) same problem here. Also the download shows only CU12.
    There is a job which downloads the file every day, so editing it won't fix it.
     
    Jürgen

  • bauerjubauerju Posts: 33 Bronze 3
    Hi Alex B
    Latest download did it.

    Thanks

    Jürgen 
Sign In or Register to comment.