No. WinCC is commercial software. The download is only available to customers with a valid license and an active Siemens support agreement. There is no "free" legal download.
Official downloads for are managed through the Siemens Industry Online Support (SIOS) portal . While Service Pack 1 (SP1) is widely documented with multiple updates, Service Pack 2 (SP2) is more commonly associated with newer major versions like WinCC V7.5 . Key Download & Update Details wincc 7.4 sp2 download