web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SQL 2017 SSRS has chan...
Microsoft Dynamics GP (Archived)

SQL 2017 SSRS has changed and PID does not work.

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,848 Moderator

I just tried to install SQL 2017 for the first time using the version downloaded in PartnerSource. They have separated out the SSRS installation to it own installation package. This package asks for a product ID. When I enter what is provided for SQL it does not work. How do I obtain a valid SSRS product ID?

*This post is locked for comments

I have the same question (0)
  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    Along with this Dynamics GP forum, this may also be a question to put into a SQL Server / Reporting Services forum as well.

    I also wanted to mention that currently, SQL Server 2017 is not compatible nor supported with any version of Dynamics GP, including GP 2018.

    Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    Derek, I have information from a very well placed Microsoft contact that SQL 2017 is about to be added to the requirements page. We now have the problem where the PID for SQL does not work with the separate install media of SSRS. Looks like another one of the consequences of someone at Microsoft not thinking this all the way through. I will let everyone know what I find out.

  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    You're correct in that SQL 2017 is being tested for compatibility with Dynamics GP 2018, which is why you can actually run GP 2018 Utilities on SQL 2017 without getting a version error, but until it's actually on the System Requirements page, it is technically not a supported environment.

    I haven't had a chance to look at SSRS and SQL 2017 but I'll make a note to do so and update this if I find anything out as well.

    Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    Thanks Derek, I was just taken aback yesterday when first I discovered that SSRS was a separate installation and then when the PID did not work we immediately put the brakes on the test upgrade. Please keep us posted.

  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    Do you have the link on Partnersource for the SQL 2017 / Reporting Services you're installing? Just so I'm testing the exact same thing.

    Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    Here is the link. The install media has many changes. They had already separated out Management Studio now they have separated out SSRS as well.

    https://mbs.microsoft.com/partnersource/northamerica/support/support-news/SQLServer2017_STD_ReleaseDownload

  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    Thank you

  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    Ok, I installed SQL 2017 using the download you mentioned and see that Reporting Services is now a separate install, for whatever reason.

    If you copy the key that was populated when you installed the initial SQL Server 2017 Standard Runtime, you can use it when you install SQL 2017 Reporting Services as well.

    docs.microsoft.com/.../find-reporting-services-product-key-ssrs

    Let me know if this doesn't work for you. I tested it and it worked for me when I did it.

    Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    I install SQL 2017 with SSRS onto brand new image to test and the same PID worked for both. I will try again on the client's server to see if perhaps they were doing something slightly different than I normally do. By the way, for your SQL 2017 installations which of these options would you check? There are several new ones for SQL 2017 and if any of them are useful for GP I would want to include them.

  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    The images are for different languages, from what I could see, so I used the English one.

    Just copy the registration keys that gets populated into the SQL 2017 install, then use that same key to enter when you're installing Reporting Services, because it doesn't automatically populate when you install SSRS from the image.

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans