WINCC V7.5 SP2 fault installing SQL Server 2016

Hello,

I'm facing a problem with installing WINCC V7.5 SP2 on a Windows 11 23H2 PC. While installing it pops-up with the error "The following program could not be installed: SQL Server 2016 SP2 Standard Edition (WinCC) Setup cannot complete the installation.

I have installed WINCC V7.5 SP2 a few times now on other Windows 11 PCs, which had the 22H2 version, without any problem.

This is the first PC I received with the 23H2 version and it doesnt let me install the SQL 2016 server.

After some research I found out that SQL Server 2016 is not supported by Windows 11, but it did work on the 22H2 version and also the compatability states it is supposed to work.

Someone here that has the same problem, or that could help me out with the problem?

Thanks in advance.

Hi,

WinCC V7.5 SP2 is released for Windows 11 Pro 23H2 as of software Update 16 (link), so the base installation should be able to finish.

Is this a new system or did you already have some software (perhaps another instance of SQL Server) installed previously?

If it is a new system, I would recommend reinstalling the operating system (please do not use images or restore points). Then, set up the system and assign a unique computer name before installing WinCC (changing the computer name after installing WinCC will cause serious problems and require a new installation). Finally, start the WinCC installation.

I really hope this helps!

Hi Itafusna,

Thanks for your reply.

It's indeed a totally new system which was installed from scratch. I will try to totally re-install Windows and afterwards change the PCs name.

Will keep you informed.

Unfortunetaly completely re-installing the PC did not work out. Still facing problems installing the SQL database.

The error I receive in the logfile from the SQL installation:

Anyone has an idea?

jvr67

Unfortunetaly completely re-installing the PC did not work out. Still facing problems installing the SQL database.

Anyone has an idea?

On systems running Windows 11, some new storage devices and device drivers exposes a disk sector size greater than the SQL supported 4-KB sector size.

First check this:

• Run Command Prompt as admin and try the command below
  
  fsutil fsinfo sectorinfo c:
  
  
• check if PhysicalBytesPerSectorForAtomicity or PhysicalBytesPerSectorForPerformance
  is greater than 4096
  
  
• if greater than 4096, open Registry Editor as admin
• Navigate to the key HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device.
  
  On the Edit menu, point to New, and then select Multi-String value.
  Name it ForcedPhysicalSectorSizeInBytes.
  Modify the new value, type in * 4095.
  Select OK and close the Registry editor.
  
  
• Reboot the system.

Hi SteBo,

That seemed to solve my problem, I was now able to install Wincc without any problem.

Thank you very much!

jvr67

Hi SteBo,

That seemed to solve my problem, I was now able to install Wincc without any problem.

Thank you very much!

Thanks for letting us know!