Getting error while Installing SQL Server 2022

Question

Getting error while Installing SQL Server 2022

Bhavish Rohilla 0

I am getting an error while installing the SQL Server with the error code - 2064908287.
Packages are downloaded successfully but unable to install. I am attaching a screenshot of the error. The log file too didn't help me in solving the error.

Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator

2023-09-07T21:03:06.78+00:00

There is no screenshot. And what we really need are the files summary.txt and details.txt. In the folder C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log you find one folder per installation attempt. These folder have plenty of files, but we are primarily interested the two aforementioned.

Don't include them in your post, but attach them.
Olaf Helper 47,621 Reputation points

2023-09-08T04:57:24.5533333+00:00

The log file too didn't help me in solving the error.

Then how could we help?

Review the logs again to find a hint about the cause.
Bhavish Rohilla 0 Reputation points

2023-09-09T07:28:21.6133333+00:00

There are so many folders at the location you mentioned. Which file in which folder do you want me to provide? I am bit confused about it
Bhavish Rohilla 0 Reputation points

2023-09-09T07:32:16.1366667+00:00

I have around 80 folders in there
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator

2023-09-09T08:31:34.3333333+00:00

As I said, there is one folder per installation attempt. Or, well, I think there are two. One for the landing page, and one for the actual Setup. So if you have 80, I guess you have tried 40 times. Quite impressive, I must say!

As you may have noticed, the folder names indicates when you ran the installation. I would suggest that you share the files from the most recent attempt.
Bhavish Rohilla 0 Reputation points

2023-09-12T16:32:38.51+00:00

Summary_MSI_20230907_133327.txt

SQLServer_ERRORLOG_2023-09-07T13.34.29.txt

SQLServer_ERRORLOG_2023-09-07T13.34.34.txt

These are the files 1 summary file and 2 errorlog files that I got from most recent folder. I hope it works
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator

2023-09-12T21:08:43.4066667+00:00

The Summary file says "Failed". But the SQL Server errorlogs seems fine to me. Can you simply try to connect from SSMS (Azure Data Studio or SQLCMD) to .\MSSQLSERVER07 and see what happens?

Wasn't there any detail.txt in that folder?
Bhavish Rohilla 0 Reputation points

2023-09-13T14:19:56.94+00:00

Yes I do have a details.txt. Here I am attaching the file.
Detail.txt
LiHongMSFT-4306 31,621 Reputation points

2023-09-28T08:15:20.1933333+00:00

Hi @Bhavish Rohilla

Do you have further question on this issue, could we offer more support?

If any answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

1 answer

Your answer

Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator

2023-09-07T21:03:06.78+00:00

There is no screenshot. And what we really need are the files summary.txt and details.txt. In the folder C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log you find one folder per installation attempt. These folder have plenty of files, but we are primarily interested the two aforementioned.

Don't include them in your post, but attach them.
Olaf Helper 47,621 Reputation points

2023-09-08T04:57:24.5533333+00:00

The log file too didn't help me in solving the error.

Then how could we help?

Review the logs again to find a hint about the cause.
Bhavish Rohilla 0 Reputation points

2023-09-09T07:28:21.6133333+00:00

There are so many folders at the location you mentioned. Which file in which folder do you want me to provide? I am bit confused about it
Bhavish Rohilla 0 Reputation points

2023-09-09T07:32:16.1366667+00:00

I have around 80 folders in there
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator

2023-09-09T08:31:34.3333333+00:00

As I said, there is one folder per installation attempt. Or, well, I think there are two. One for the landing page, and one for the actual Setup. So if you have 80, I guess you have tried 40 times. Quite impressive, I must say!

As you may have noticed, the folder names indicates when you ran the installation. I would suggest that you share the files from the most recent attempt.
Bhavish Rohilla 0 Reputation points

2023-09-12T16:32:38.51+00:00

Summary_MSI_20230907_133327.txt

SQLServer_ERRORLOG_2023-09-07T13.34.29.txt

SQLServer_ERRORLOG_2023-09-07T13.34.34.txt

These are the files 1 summary file and 2 errorlog files that I got from most recent folder. I hope it works
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator

2023-09-12T21:08:43.4066667+00:00

The Summary file says "Failed". But the SQL Server errorlogs seems fine to me. Can you simply try to connect from SSMS (Azure Data Studio or SQLCMD) to .\MSSQLSERVER07 and see what happens?

Wasn't there any detail.txt in that folder?
Bhavish Rohilla 0 Reputation points

2023-09-13T14:19:56.94+00:00

Yes I do have a details.txt. Here I am attaching the file.
Detail.txt
LiHongMSFT-4306 31,621 Reputation points

2023-09-28T08:15:20.1933333+00:00

Hi @Bhavish Rohilla

Do you have further question on this issue, could we offer more support?

If any answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Answer 1

This appears to be the key line:

PerfLib 2.0 counter removal failed with exit code 2. Command line: C:\WINDOWS\system32\unlodctr.exe /m:hkengperfctr.xml from directory C:\Program Files\Microsoft SQL Server\160\Shared.

Error 2 is usually "File not found". Can you check whether you have a file C:\Program Files\Microsoft SQL Server\160\Shared\hkengperfctr.xml?

Then again, my reading of the log file is that although this operation fails, Setup still seems to jog along and complete its work. Which kind of making sense, because the PerfCounter removal is not likely to be critical.

Have you tried connecting to one of your quite many SQL Server instances? What do you see in the SQL Server Configuration Manager?

(Also, please use comments to post any answers to my question. The Answer window is for answers to the original problem.)

Share via

Getting error while Installing SQL Server 2022

1 answer

Your answer