December 19, 2023 at 2:57 pm
Interesting issue I ran into. I have 2019 SQL Server standard edition where I uninstalled it (reboot the server) then I installed as 2019 developer edition database instance. However when I do the same for 2019 SSRS where uninstalled (reboot) and then through wizard I select developer edition during installation then click next to install and after installation is completed. I open the SSRS configuration and it show edition as SQL Server Standard as you know I have installed developer edition for 2019 SQL Instance to connect to SSRS and it does not connect because it say select is not valid for this edition.
why during it is not installing as developer edition even though I selected as developer.
December 19, 2023 at 4:00 pm
As a random thought, are you fully patched on both SSRS and SQL Server?
Also, when you uninstalled Standard, did you reboot after the uninstalls? And did you reboot after the re-installs?
The steps I would take are to uninstall 2019 SQL Server standard, uninstall SSRS, reboot, double-check that it is completely uninstalled (nothing in add/remove programs related to SQL 2019), then install 2019 SQL Server Developer and double check that it came in as developer, then install all updates and reboot as needed. Next, reinstall 2019 SSRS and double check that it came in as developer, then install all updates and reboot as needed.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 19, 2023 at 4:40 pm
Looks like some remnants of previous installation remained in the registry. you may have to repeat the cycle of uninstall and re-install of the products in reverse order first. Some in between pauses for rebooting the machine to re-initiate the install.
This should not take more than an hour or so. Give it a try.!!
=======================================================================
December 19, 2023 at 4:48 pm
Yes, I have rebooted every time I uninstall the product. Also I have not found different version of report server in 2019. However I have applied latest patched on database instance before installing SSRS
Yes I did saw from app&Features the report services is removed only then I re-installed it.
This is a downloadable file to install ssrs which I used
https://www.microsoft.com/en-us/download/details.aspx?id=100122
informational link.
Still did not find a solution.
December 19, 2023 at 6:21 pm
Is the report server DB on a Standard Edition instance?
There was something if i remember correctly that it will pull the edition of the SQL instance as what you want as your RS edition.
December 19, 2023 at 6:28 pm
This was removed by the editor as SPAM
December 21, 2023 at 5:36 am
Have you tried to repair the SQL installation? Clean registry / ensure programs are un-installed correctly.
If yes, then re-install on a different folder. This helps sometimes.
Note: As always, please check these steps in a test platform to make sure they work well.
DBASupport
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply