False server down alert from the monitoring server.

Server team changed dns name and ip address for server XXY.After that, we were receiving sql host down alert from the monitoring server YYX for the server XXY.What we do to stop that false alerts?

Resolution steps:

  1. Go to the following path file://yyx/c$/WINDOWS/system32/drivers/etc
  2. Find host file inside the etc folder.
  3. Open the hosts file in the notepad and it shows like below comments#.
  4. Add newserveripaddress   servername in the bottom content of the file.

# Copyright (c) 1993-1999 Microsoft Corp.
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
# For example:
#     rhino.acme.com          # source server
#     x.acme.com              # x client host       localhost XXY#we need to include new ip and hostname.

I’ve updated the host file in the monitoring server (YYX) to refer the new ip of XXY server.

That’s it.

Note: We need to change as per above notes after domain change and ip change.


Popular posts from this blog

SQL Server:Steps to Configure Database Mirroring by T-SQL Script.

SSIS2008R2 Error: 0xC0209303 at Package: