Unable to distribute after the upgrade

lalajee 1,811 Reputation points
2023-12-15T11:29:02.4666667+00:00

Hi,

We have upgraded our sccm server from 2303 to 2309 but now we cant distribute any packages

Following was done when we upgraded

  • When try to update it ask for "Microsoft ODBC Driver 18"
  • After installing this "Microsoft ODBC Driver 18" it create more issue e.g. "Failed to connect to the SQL Server, connection type: SMS ACCESS."
  • After changing SSL for sql to no upgraded worked fine

User's image

  • Distribute and build was working fine too

After change the SSL for sql to yes we cant build or distribute any packages

PkgXferMgr.log show

*** [08001][-2146893022][Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The target principal name is incorrect.	SMS_PACKAGE_TRANSFER_MANAGER	13/12/2023 04:04:41	8376 (0x20B8)
*** [08001][-2146893022][Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection	SMS_PACKAGE_TRANSFER_MANAGER	13/12/2023 04:04:41	8376 (0x20B8)
*** Failed to connect to the SQL Server, connection type: SMS ACCESS.	SMS_PACKAGE_TRANSFER_MANAGER	13/12/2023 04:04:41	8376 (0x20B8)
IsSafeToGetSCF: Failed to get SQL connection	SMS_PACKAGE_TRANSFER_MANAGER	13/12/2023 04:04:41	8376 (0x20B8)
Info: Currently Site 999 is initializing Site Control Data. Can't get SCF from database at this time. Will try later.	SMS_PACKAGE_TRANSFER_MANAGER	13/12/2023 04:04:41	8376 (0x20B8)
*** [08001][-2146893022][Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The target principal name is incorrect.	SMS_PACKAGE_TRANSFER_MANAGER	13/12/2023 04:04:42	8376 (0x20B8)
*** [08001][-2146893022][Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection	SMS_PACKAGE_TRANSFER_MANAGER	13/12/2023 04:04:42	8376 (0x20B8)
*** Failed to connect to the SQL Server, connection type: SMS ACCESS.	SMS_PACKAGE_TRANSFER_MANAGER	13/12/2023 04:04:42	8376 (0x20B8)
Failed to get SQL connection	SMS_PACKAGE_TRANSFER_MANAGER	13/12/2023 04:04:42	8376 (0x20B8)
Microsoft Configuration Manager Deployment
Microsoft Configuration Manager Deployment
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Deployment: The process of delivering, assembling, and maintaining a particular version of a software system at a site.
929 questions
Microsoft Configuration Manager
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sherry Kissinger 4,136 Reputation points
    2023-12-15T14:49:05.62+00:00

    Potentially stupid question, but I have to ask. 'even though', post-install of the odbc driver for sql, it does not TELL you that a reboot is needed... a reboot is needed. Did you reboot the server(s) yet ? If not... "reboots often magically fix a myriad of issues". Try it?

  2. Simon Ren-MSFT 31,756 Reputation points Microsoft Vendor
    2023-12-18T08:41:13.5833333+00:00

    Hi,

    Thank you for posting in Microsoft Q&A forum.

    Have you already installed Microsoft ODBC Driver 18 on every node that has the site system role installed before the upgrade process. Similar threads for your reference:

    Microsoft ODBC driver 18 for SQL setup Issue with SCCM 2309 Upgrade

    Fix SQL Client Prerequisite missing for SCCM Setup Error

    Thanks for your time. Have a nice day!

    Best regards,

    Simon

    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.