Error when installing Microsoft Sql Server 2019, cannot find the microsoft OLE DB Driver

Question

Error given

I am having trouble installing Microsoft SQL server 19 Express (I tired dev aswell, it does the same thing). It keeps giving me the error:

Error Description: An installation package for the product Microsoft OLE DB Driver for SQL server cannot be found, Try installing again using a valid copy of the installation pacakage 'msoledbsql.msi'

So what I tried was redownloading it from https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15 and running the .msi file. It runs fine and gives no errors but it still does not fix the issue. It still will not find the file and without it I cannot install the program. Or am I using the wrong driver for it? The other thing I have tried is when clicking on the .msi it gives me the option to remove or repair. I've done both as well (reinstalling after remove) but it still gives me the error. I'm very very lost at this point. Could anyone possibly help?

Missile

Have a look at links in the comments on this question: #71757117 – Elgin

@Elgin That link now points to a SO question that was removed, so it no longer works (at least for me) – Seppuku

@ReversedEngineer Indeed... There were a couple of related questions from the time that question was asked and they are all deleted now. If I remember the conversation correctly, it boiled down to a bug in the installer. – Elgin

Answer 1

I managed to fix it, first, you need to go to programs and features and uninstall the "Microsoft OLE DB Driver for SQL Server" that is there and then let the installer install the new one

Missile

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center. – Haemostatic

Thanks, it worked for me as well. I removed all OLE and ODBC drivers, then it worked. – Tinhorn

Thanks, this worked like a charm. I think I got this error because I installed SSMS first and then installed when trying to install SQL2019-SSEI-Eval I got this error. – Gusti

but my concern is why remove new version to replace with old one? isnt that a bug and should be reported to microsoft? Whichever software installed the latest version must have done it for a reason. – Stereoisomerism

This also fixed the same issue when installing SQL Server 2022 Developer Edition. – Workingwoman

Thanks @kartikghodasara for pointing this, I also installed the management studio first. Then while trying to install server I faced the same problem. – Efferent

Answer 2

Simply uninstall existing ole db then run your sql server setup afresh

Paramorph

Answer 3

I was getting similar error when trying to install SQL Server 2022 developer edition. When I tried to install OLEDB driver, It gave me error that it needs VC++ redistributable. I tried to install X64 version VC++ redistributable (https://aka.ms/vs/17/release/vc_redist.x64.exe) but was still getting same error. Finally, this error was fixed when I installed 32 bit version using https://aka.ms/vs/17/release/vc_redist.x86.exe

Tapping

It must be a bug in the installer that looks for only the x86 version. I ran into this error in previous versions of SQL Server. It's still present for SQL Server 2022 Developer Edition. – Seniority

Answer 4

We were trying to install SQL Server 2019 Developer Edition on our existing server which already had the Standard edition installed earlier and we were getting the below error:

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'.

Solution: The OLEDB and ODBC drivers were already installed on the server so I first uninstalled them, then I was able to install SQL Server 2019 Developer Edition. So we always have to uninstall the existing OLEDB and ODBC drivers first because the SQL Server setup installs the OLEDB and ODBC drivers itself.

Powe

Answer 5

remove all OLE and ODBC drivers and re run the setup

Category

Answer 6

I deleted ALL "Microsoft ODBC Driver"s and "Microsoft ODBC Driver"s and then the new install of SQL Server worked. After installing it, I had 2 new "OBCD Driver"s and one "OLD DB Driver for SQL Server" in Programs and Features. And note, after the install, I now had about 25 different "Microsoft SQL Server"s installed,from "2008" to "2022".

Grouping