Comments on: SCCM SQL Server Upgrade from 2014 to 2017 https://www.prajwaldesai.com/sccm-sql-server-upgrade/ SCCM | ConfigMgr | Intune | Windows 11 | Azure Mon, 06 Jun 2022 21:56:54 +0000 hourly 1 https://wordpress.org/?v=6.4.1 By: Jason https://www.prajwaldesai.com/sccm-sql-server-upgrade/#comment-38292 https://www.prajwaldesai.com/?p=214996#comment-38292 In reply to Bobby G.

I had the same question…

]]> By: George https://www.prajwaldesai.com/sccm-sql-server-upgrade/#comment-36579 https://www.prajwaldesai.com/?p=214996#comment-36579 Hi Prajwal, thank you for the guide. I’ve always wondered about how, during the SQL server upgrade, you’ve handled the SUSDB that is shown in your screenshots.

]]> By: Prajwal Desai https://www.prajwaldesai.com/sccm-sql-server-upgrade/#comment-31794 https://www.prajwaldesai.com/?p=214996#comment-31794 In reply to Mike.

Glad to hear that. Keep visiting the blog for more awesome posts.

]]> By: Mike https://www.prajwaldesai.com/sccm-sql-server-upgrade/#comment-31793 https://www.prajwaldesai.com/?p=214996#comment-31793 This is an awesome Blog, Step by Step without any issues. I upgraded from SQL 2012 to 2019.

]]> By: Hello IT https://www.prajwaldesai.com/sccm-sql-server-upgrade/#comment-30748 https://www.prajwaldesai.com/?p=214996#comment-30748 Used your procedure to get from SQL 2012 SP4 right to SQL2019 CU14 on SCCM 1710. Worked flawlessly! Thanks. 🙂

]]> By: Nik https://www.prajwaldesai.com/sccm-sql-server-upgrade/#comment-29032 https://www.prajwaldesai.com/?p=214996#comment-29032 Hello,
Do we need a key for the new Reporting Services, or can we use the Developer version?
After the Upgrade, I saw SQL Server Integration Service 12.0 Stopped and cannot be enabled, and raised the red flag on Server Dashboard. Do we need to uninstall SSIS 12.0, and what is the best practice in this case?

]]> By: Cate https://www.prajwaldesai.com/sccm-sql-server-upgrade/#comment-27105 https://www.prajwaldesai.com/?p=214996#comment-27105 HI Prajwal, Can I Use the same process to 2019?

sccm sql server upgrade from 2014 to 2019

]]> By: Bobby G https://www.prajwaldesai.com/sccm-sql-server-upgrade/#comment-23461 https://www.prajwaldesai.com/?p=214996#comment-23461 In your exercise, you removed the Reporting Services DB and Reporting Service TempDB. Can those DBs be upgraded when you upgrade from SQL 2014 to 2017 instead? Is there a particular reason why they needed to be removed?

]]> By: Ritesh Khandelwal https://www.prajwaldesai.com/sccm-sql-server-upgrade/#comment-20845 https://www.prajwaldesai.com/?p=214996#comment-20845 Thanks for the wonderful explanation. This is really helpful.

I have scenario where I need to perform edition downgrade from SQL server enterprise to standard edition for cost efficiency purpose.
But that server have reporting services also which I am failing to reconfigure after performing edition downgrade.

Will the same process(which you followed in your upgrade) for SSRS reconfigure works while edition downgrade or some different approach is required?

Can you please help me providing your expertise.

Thanks in advance

]]> By: laura https://www.prajwaldesai.com/sccm-sql-server-upgrade/#comment-19572 https://www.prajwaldesai.com/?p=214996#comment-19572 Hi, I have this scenario:

CAS and reporting with sql 2012
6 primary sites with sql 2012 version.
Is possible migrate the CAS SQL database and reporting database to sql 2017 keeping the 6 primary sites with sql 2012?

what about replication?

Thanks

]]>