15

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?

squillman
  • 13,363
  • 3
  • 41
  • 60
Adi Miller
  • 681
  • 1
  • 5
  • 8
  • Have a look at links in the comments on this question: https://stackoverflow.com/questions/71756617/sql-server-2019-developer-edition-download-failed – squillman Apr 13 '22 at 12:24
  • @squillman That link now points to a SO question that was removed, so it no longer works (at least for me) – Reversed Engineer Aug 10 '22 at 10:51
  • 1
    @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. – squillman Aug 10 '22 at 12:43

3 Answers3

43

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

Kamarey
  • 10,832
  • 7
  • 57
  • 70
Adi Miller
  • 681
  • 1
  • 5
  • 8
  • 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](/help/how-to-answer). – Community Apr 13 '22 at 16:38
  • 4
    Thanks, it worked for me as well. I removed all OLE and ODBC drivers, then it worked. – Attila Jun 02 '22 at 09:17
  • 1
    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. – kartik ghodasara Nov 12 '22 at 11:03
  • 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. – user734028 Jul 16 '23 at 08:35
1

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

onyangofred
  • 74
  • 5
0

remove all OLE and ODBC drivers and re run the setup

Manvendra Singh
  • 21
  • 2