I do not know what exact model you have. Asus has 27 different Z790 motherboards and revisions. You can try to install the Windows 10/11 drivers Asus provides or contact Asus to see if they offer Windows Server specific drivers. The majority or your drivers, if not provided with the OS, should be available directly from the chipset manufacturer (Intel, Realtek, Marvell, etc.). Obtaining the latest Intel Nic Server 2022 drivers may be enough to get you connected to pull the remainder of the drivers from Windows Update or the Microsoft Update Catalog.
IntelĀ® Network Adapter Driver for Windows Server 2022 [intel.com]