SQL Server 2022 Express installation error

Question

SQL Server 2022 Express installation error

54321 0

Hello, I am facing with installation error of SQL Server 2022 Express Edition.
I have attached error files and a screenshot with an error right after it appeared. I've been trying to find some solutions in the internet, but nothing really fits to my issue.
I would much appreciate for any help, because I don't know what is going on. Screenshot 2023-04-09 130707

Detail.txt Summary.txt Thank You. BR, Barath

4 answers

Your answer

Answer 1

Erland Sommarskog 121.4K MVP Volunteer Moderator

It seems from the Summary file that you have tried to install quite a few number of times. Is that correct?

At this point, I am not sure if the error we see is the genuine error or a consequence of the original failure. In any case, in details.txt the place where things start to downhill is with this error:

File 'C:\Program Files (x86)\Microsoft SQL Server\160\Shared\sqlmgmprovider.mof' not found!

Could you check if you have any all-digit folder in C:\Program Files (x86)\Microsoft SQL Server\160\Shared and see if the mof file might be there? Then again, I believe that Setup removes this file before it exits, at least when everything goes well.

Also, since you are on Windows 11, can you check C:\Program Files\Microsoft SQL Server\MSSQL16.xxxxxxx\MSSQL\LOG if you have a file ERRORLOG in that folder? xxxxxx stands for all such folders that you have. If you find an ERRORLOG file, can you attach it? You need to rename it to ERRORLOG.txt for the forum software to accept it.

Recep Özgür MIH 20 Reputation points

2023-04-09T14:23:44.3633333+00:00

I am also facing the same problem. can you help me Detail.txt ERRORLOG.txt ERRORLOG.1.txt ERRORLOG.2.txt sqlmgmprovider.mof.png
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-04-09T15:10:44.66+00:00

Recep, to avoid confusion, can you ask a new question, including the same information? I know what is your problem, but 54321 may be running into something else.
54321 0 Reputation points

2023-04-09T16:45:23.9366667+00:00
You're Right I've tried to Reinstall Quite few a times.

There was no mof file at C:\Program Files (x86)\Microsoft SQL Server\160\Shared

Also i have checked for C:\Program Files\Microsoft SQL Server\MSSQL16.xxxxxxx\MSSQL\LOG There was'nt any LOG folder or file either Screenshot 2023-04-09 221146.png
54321 0 Reputation points

2023-04-09T16:49:16.03+00:00

ALSO This is the what i found when i checked for C:\Program Files\Microsoft SQL Server\MSSQL16.xxxxxxx\MSSQL\LOG FOR THOSE ERROR LOGS There was'nt any LOG folder or file either Screenshot 2023-04-09 220352.png
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-04-09T17:29:55.0333333+00:00
Thanks for the information!

It's good to know that you don't have any ERRORLOG. This means that the installation never came that far, and we can focus on the missing sqlmgmprovider.mof. I can think of three things:

Setup is never able to write it to C:\Program Files (x86)\Microsoft SQL Server\160\Shared.

It writes it to a subfolder with an LCID. (Recently I tried to help someone where the problem was the reverse. The file was in that folder, but MSI wanted to read it from a subfolder.)

The file is written to the folder alright, but is then removed, for instance by an over-zealous anti-virus.

One thing you could try is yet another installation but this time with Process Monitor running. Process Monitor is not the easiest tool to use, but you would filter for sqlmgmprovider.mof to see what is happening.
54321 0 Reputation points

2023-04-09T18:21:31.58+00:00

Hey can i share the PML log file while attempting to install SQL server Express and can you figure out whats happening here
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-04-09T18:34:13.8966667+00:00

You can share it and maybe someone will look at it, but I don't know that much than you do. The SQL Server setup is something that requires a quite different skillset from SQL Server itself. I only have a vague notion what a MOF file is.
54321 0 Reputation points

2023-04-09T19:03:42.42+00:00

This is the Pml file I recorded while attempting to install Sql server EXPRESS and i have filtered it to (path contains sqlmgmprovider.mof)
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-04-09T19:14:36.2+00:00

If that is the only entry with that file name, it suggests that Setup never created the file. Why, I don't know. But I am by no means an expert in this field. Maybe we need to widen the filter, but how I don't really know. But maybe just "path contains .mof."

But it is worth mentioning that many errors like this are due to that your machine is messed up. I recently had problems with the most recent Windows update did not install. I ended up running the ISO for Windows 11 22H2 again. No, I did not reformat the disk and that. Basically, it was a repair.
54321 0 Reputation points

2023-04-09T19:36:17.59+00:00
Hey i have filtered it to just (path contains .mof ) it gives 359 events &the file size is 5mb and it says that i cant upload here

Is there like any other ways that i can start from first place again

Or is there any other person you can refer for this issue

By the way, i appreciate your help and responses.
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-04-09T19:42:06.3633333+00:00

You could upload the file some other site and drop the link here.

This is a public forum, so there may be more people who can chime in.

But I would encourage to try to understand the data from Process Monitor yourself. I know, it is not trivial. I fumble quite a bit myself for my own troubleshooting. But the problem is with your machine. And keep in mind that this is a forum for peer support. It's not like you open a support ticket, and lean back and you can expect someone to do the hard work. You have to do some on your own as well.

Answer 2

Anonymous

Hi @54321 I found this error in your detail log. User's image

This error is usually caused by the previous failed installation of SQL Server has not been completely uninstalled, so we need to completely uninstall the previous failed installation first. You can check this link, troubleshoot after downloading and perform an uninstall of all SQL Server and use to uninstall the old version. https://support.microsoft.com/en-us/topic/fix-problems-that-block-programs-from-being-installed-or-removed-cca7d1b6-65a9-3d98-426b-e9f927e1eb4d For more information, you can also refer to this link: https://stackoverflow.com/questions/63636622/sql-install-error-the-mof-compiler-could-not-connect-with-the-wmi-server. Best regards, Aniya

54321 0 Reputation points

2023-04-10T09:24:59.8366667+00:00

......
54321 0 Reputation points

2023-04-10T09:35:33.6666667+00:00
Hi @Anonymous i Have tried to completely uninstall and install again ,It shows the folllowing Error

i have attached the Details, Summary & ERROR LOGS

Summary.txt

Detail.txt

SQLServer_ERRORLOG_2023-04-10T09.50.16.txt

SQLServer_ERRORLOG_2023-04-10T09.50.17.txt

SQLServer_ERRORLOG_2023-04-10T09.50.18.txt

SqlWriter_Cpu64_1.log

Also i Have McAfee anti_virus Does that Affect this?
Anonymous

2023-04-11T01:16:49.74+00:00

Hi @54321 In your log, I checked this message: "There have been 256 misaligned log IOs, which required falling back to synchronous IO. The current IO is on file C:Program FilesMicrosoft SQL ServerMSSQL16. SQLEXPRESS21MSSQLTemplate Datamaster.mdf.” You need to operate and check this link: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size. Best regards, Aniya
54321 0 Reputation points

2023-04-11T13:30:21.3533333+00:00
@Anonymous @Erland Sommarskog I have tried the Method you've said to change registry keys and now it gives a error like this without any description

SQLServer_ERRORLOG_2023-04-11T18.04.36.txt

SQLServer_ERRORLOG_2023-04-11T18.04.39.txt

SQLServer_ERRORLOG_2023-04-11T18.04.43.txt

Detail.txt

Summary.txt

sql_engine_core_inst_Cpu64_1.log

Also i tried to understand the Error log file i found multiple occurences like this

Package ID sql_fulltext_SQL11_Cpu64: NotInstalled

Sco: File 'C:\SQL2022\Express_ENU\1028_CHT_LP\x64\setup\x64\sql_engine_core_inst_loc.msi' does not exist

Not sure if this is the error

Not sure what i should do next

Answer 3

Erland Sommarskog 121.4K MVP Volunteer Moderator

This possibly suggest that you have resolved the issue with the mof file, because you are now coming as far as getting an errorlog.

And there are somewhat good news. This is a known issue where Windows 11 for certain disk drives that SQL Server is not able to cope with. Microsoft has published an article with workarounds for the problem.

Answer 4

Erland Sommarskog 121.4K MVP Volunteer Moderator

The mof compiler is causing trouble again. However, judging from your errorlog, SQL Server is actually up and running. Open a command line window and run

SQLCMD -S .\SQLEXPRESS24

are you able to connect? If so, maybe it is best to leave things are they are.

Share via

SQL Server 2022 Express installation error

4 answers

Your answer