SCCM 2006 and SQL 2012 SP4

R , R 1 Reputation point
2021-01-31T23:39:15.1+00:00

Hi All,
I am wondering if there is any known issues with SCCM 2006 and SQL 2012 SP4.
We have 1 CAS and 3 Primaries.
I am about to patch the 2012 SQL database to SP4. I would like to confirm that there is no known issues with this patch level.
Once the DB is patched, I will upgrade SCCM to 2010 CB.
Any advice will be appreciated.
Many thanks.
RR

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,872 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Jason Sandys 31,176 Reputation points Microsoft Employee
    2021-02-01T02:49:35.023+00:00

    Well considering you've been running in an unsupported state for a while now, upgrading to SP4 is a very good thing (SP3 hasn't been supported since the end of 2018). You should also consider moving to a newer version of SQL Server as 2012 reached its end of life in just over a year. See https://learn.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-2012.

    0 comments No comments

  2. R , R 1 Reputation point
    2021-02-01T02:54:46.13+00:00

    Thanks Jason,
    I am going to move off SQL 2012 in the next 6 - 12 months. However, I have to keep it up to date for the time being.
    I will be soon asking about the best practices to upgrade both the DB servers and the primaries as they are all on 2012 R2.

    Cheers,
    RR

    0 comments No comments

  3. AllenLiu-MSFT 41,136 Reputation points Microsoft Vendor
    2021-02-01T03:13:13.22+00:00

    @R , R
    Thank you for posting in Microsoft Q&A forum.
    There is no known issues for SCCM with SQL 2012 SP4.
    The official documentation said we can use version SQL Server 2012 with the minimum service pack and cumulative update supported by the SQL Server lifecycle. You can use this version of SQL Server for the following sites:
    A central administration site
    A primary site
    A secondary site
    Here is the reference to upgrade the OS of site system and SQl Server:
    https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/upgrade-on-premises-infrastructure


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments