We are testing upgrading the OS on our SQL Servers to Windows Server 2025, doing an in-place upgrade of the OS (SQL Server version is not changing.)
After doing the update, we had to re-do the permissions for the Monitor service account, as we want to avoid adding it to the local Administrators. Despite setting the permissions as listed in the Monitor documentation, the account was not able to access the WMI root and CIMv2 folders. Adding the account to the local Administrators worked around the issue.
Lastly, the “wmic useraccount…” command to get the SID of the Monitor service account did not work in Windows Server 2025, we instead had to use Powershell (get-aduser -identity “service account” | select-object name,sid"
We are testing upgrading the OS on our SQL Servers to Windows Server 2025, doing an in-place upgrade of the OS (SQL Server version is not changing.)
After doing the update, we had to re-do the permissions for the Monitor service account, as we want to avoid adding it to the local Administrators. Despite setting the permissions as listed in the Monitor documentation, the account was not able to access the WMI root and CIMv2 folders. Adding the account to the local Administrators worked around the issue.
Lastly, the “wmic useraccount…” command to get the SID of the Monitor service account did not work in Windows Server 2025, we instead had to use Powershell (get-aduser -identity “service account” | select-object name,sid"