Change SQL Virtual IP from DHCP to Static IP

This blog is for database administrators who wants to change SQL server virtual IP address from DHCP to static IP address. Sometimes when you try to change IP address from IP address resource properties to static IP from DHCP you will get an error saying can not change the properties of SQL server IP address (networkname), there…