This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 97%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 16%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Need to uninstall OLE and ODBC before installing/upgrading
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 82%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
This worked for me. Attempting to install the driver, or point the installer at the .msi file did not help.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 83%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFD%3C/text%3E%3C/svg%3E)
Total nightmare. Dreadfull installation. Dead Wizard. About 10 goes of typing in the same things over and over again.
Installing Oracle was less of a hassle and that says everything about this half-finnished, and as is usual with this marketing led concern, untested shody release which no own bothered to fix
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 34%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Worked for me. thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 30%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
That's desperate. It's always "give us contact, give us feedback" and then you come across this. Years old bug!!! Nobody reads the feedback, they don't give a shit about user problems, the contacts are just to give them somewhere to send ads. If I can avoid something from Microsoft, I will avoid it. And if I can't avoid it, I suffer.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 9%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Thanks John Tsai , works for me
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:
=> Version 17
Please try to install ODBC manually to see if it could resolve the issue.
Regards，
Zoe Hui
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.
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
You need to install Microsoft OLEDB Driver.
Here is its download page: https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16