SSMS 19 installation fails immediately with fatal error (0x80070643) "Microsoft OLE DB Driver for SQL Server: The required IACCEPTMSOLEDBSQLLICENSETERMS=YES Parameter missing

David Risso 10

Getting this on developers PCS (windows 10) when trying to install SSMS 19.x

SSMS 19 installation fails immediately with fatal error (0x80070643) "Microsoft OLE DB Driver for SQL Server: The required IACCEPTMSOLEDBSQLLICENSETERMS=YES Command-line Parameter is missing..etc..."

Screenshot 2023-07-05 113641

OLE DB is installed already and is the latest version (19.x)

SSMS Log can be found here: https://pastebin.com/1bjXRh8U

Is there any way to make ssms installer skip the ole db check/install ?

Erland Sommarskog 110.4K Reputation points MVP

2023-07-05T10:25:09.4866667+00:00

You say developers in plural, so this happens on more than one machine?

Myself, I had MSOLEDBSQL19 installed on my machine before SSMS 19 appeared on the scene, and I never had any problems.

Judging from the screenshot, you are trying to install the English version of SSMS. What about the OS? Is that also an English version or something else?

For the record, I have no idea what is going on, and I don't think there is no way skip this step. And while it is not uncommon to see posts with installation failures, this is certainly a new one.
David Risso 10 Reputation points

2023-07-05T11:52:27.41+00:00

Yes its happened to two machines so far - all English
Some more background info - on the machines that never had OLE DB it works, OLE DB 18.6.5 seems to get installed by SSMS 19.

I'm just going to uninstall all OLE DBs on the developer machines and try again
Erland Sommarskog 110.4K Reputation points MVP

2023-07-05T12:06:10.9766667+00:00

OK. Let us know how that works out.

1 answer

David Risso 10 Reputation points

2023-07-05T12:42:47.9833333+00:00

Finally got it to work!

Uninstalled all OLE DB versions installed on the PC - rebooted
Attempted another install of SSMS 19 - no dice, still gave the error.
Installed OLE DB 18.6.5 - it mentioned in the install that an older version was installed and that it would upgrade it. (I had uninstalled all versions found but hey registry keys and all that)
Then installed SSMS 19 and it installed OK!

My conclusion is there is some magical pixie dust in OLE DB 18.6.5....
as I had already ran SFC /scannow DISM cleanup-image etc...
Please sign in to rate this answer.

2 people found this answer helpful.
Erland Sommarskog 110.4K Reputation points MVP

2023-07-05T12:51:20.56+00:00

Spooky! Anyway, I am glad to hear that you got things working!

David Risso 10 Reputation points

2023-07-05T13:18:30.7166667+00:00

Thanks I posted here as I could not find anything on the web with the exact same error incase it happens to someone else.

Oudsen, Jos 0 Reputation points

2023-09-10T23:04:10.9133333+00:00

Had the same problem, installing OLE DB 18.6.5. before running the install package fixt it. Thx for mentioning this.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SSMS 19 installation fails immediately with fatal error (0x80070643) "Microsoft OLE DB Driver for SQL Server: The required IACCEPTMSOLEDBSQLLICENSETERMS=YES Parameter missing

1 answer

Your answer