SQL Express 2022 Installation is failing with error code - 2068052310

2024-06-03T16:18:25.3066667+00:00

Hello Team,

Prerequisite:

SQL 2019 Express is installed and working properly.

Action performed:

SQL Express 2022 Installation is failing with error code 2068052310 in my Windows 10 (22 H2) machine.

below message is from the Summary.txt which was created by SQL installer

Feature: SQL Server Replication

Status: Failed

Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.

Next Step: Use the following information to resolve the error, and then try the setup process again.

Component name: Microsoft OLE DB Driver for SQL Server

Component error code: 1706

Component log file: C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20240529_175257\msoledbsql_Cpu64_1.log Error description: An installation package for the product Microsoft OLE DB Driver for SQL Server cannot be found. Try the installation again using a valid copy of the installation package 'msoledbsql.msi'. Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=16.0.1000.6&EvtType=msoledbsql.msi%40InstallFiles%401706

when I searched against the error code, I found suggestions to uninstall ODBC driver 17 and retry the SQL installation.

I could not find the root cause why this issue would occur. It would be of great help if someone please tell me if this can be detected before hand. We can mention this in readme, asking user to do a pre check and then perform the installation.

Thank you

regards,

Karthik

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,210 questions
{count} votes

1 answer

Sort by: Most helpful
  1. LucyChenMSFT-4874 2,825 Reputation points
    2024-06-04T05:43:22.5166667+00:00

    Hi @D. P., Karthik (ADV D AA SGI PS EA-MED DPS),

    Thank you for reaching out and welcome to Microsoft Q&A.>

    I could not find the root cause why this issue would occur.

    Notice that you have setup the SQL Server 2019 Express successfully, this means you already have ODBC 17 Driver for SQL Server installed.

    So, when you want to install the SQL Server 2022 Express, it will get confused when the existing driver is not of the same version as in the installation package. The method to resolve the issue is uninstall ODBC driver 17 and retry the SQL installation.

    Here is an article that fully describes how to troubleshoot it when he encountered this situation like yours, hope this can help you know more.

    if this can be detected before hand.

    In addition to what is mentioned above, if you preinstalled SSMS, you could also get the same error message you post.

    User's image

    Please feel free to share your issue here if you have any confused.

    Best regards,

    Lucy Chen


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.

    https://docs.microsoft.com/en-us/answers/support/email-notifications