We are using one IIS server and Database server for our organization’s internal use. The Database server has two LAN cards with the following IP addresses, 192.168.0.12 and 192.168.0.112. When we ping the database server by machine name, we get a reply from 192.168.0.112; however, sometimes we get request timed out from this IP.
To fix it, I have to disable and enable the LAN card. Due to this, the connection between the IIS server and Database server breaks, and all of our application are effected. Our database administrators cannot access our database server during this because their SQL Server instance is named after our database server. Can you please help me regarding this?