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