SQL Server 2022 Developer Edition - Installation of the SSIS Integration Services

Question

Hello to all,

I have been trying to do the one Integration Services installation on my SQL Server 2022 Developer Edition environment. Unfortunately I always get errors during the installation, these are mainly related to the installation of Microsoft OLE DB Driver for SQL Server.
The message is:
The feature you are trying to use is on a network resource that is unavailable.
Use source:
C:\ProgramData\Package Cache{CD711320-8704-46EF-8B09-0F40BD2A4C2F}v18.6.5.0\x64\

If I then use the 'Cancel' button, the following message appears;
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'.

The next error message is then:
Microsoft ODBC Driver 17 for SQL Server and the following reousce is searched:
C:\ProgramData\Package Cache{CBA9B46D-5C8E-46F9-94B4-7024400EDE52}v17.10.3.1\x64\

Can anyone please offer help, I am currently evaluating the ETL tool for my company and would like to map the whole process with SSIS. But I am blocked now.

Thank you very much in advance.

The summary log file says the following:

Detailed results:
  Feature:                       Scale Out Worker
  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\20230220_101823\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.1050.5&EvtType=msoledbsql.msi%40InstallFiles%401706

  Feature:                       Scale Out Master
  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\20230220_101823\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.1050.5&EvtType=msoledbsql.msi%40InstallFiles%401706

  Feature:                       Integration Services
  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\20230220_101823\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.1050.5&EvtType=msoledbsql.msi%40InstallFiles%401706

Answer 1

This issue can happen if you have any version of Microsoft OLEDB or ODBC drivers already installed. INstalling another driver on top of it won't fix. The set up seems to do a pre check and not extract those two msi because it understand it will not use it, but then it tries to install them and the files are not there, of course.

To fix, go to add/remove programs and remove any version of microsfot oledb and odbc, then relaunch the setup.

Answer 2

Microsoft ODBC Driver 17 for SQL Server and the following reousce is searched:

You can try to install the ODBC manually before, to advoid this issue:

https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16

=> Version 17

Answer 3

Hi to all,

Thank you for your sucestion. I wil try to install the driver manually, so that perhaps the installer will skip this section of the procedure.
I will let you know.

Answer 4

Hi @Alessandro Di Pasquale

Please try to install ODBC manually to see if it could resolve the issue.

Regards，

Zoe Hui

Answer 5

Hi to all.

I am not getting anywhere, the setup wizard still has a problem with the missing msoledbsql.msi.

Do you have another idea? Thank you very much for your help.

Alessandro