Post reply

For which IP(Physical IP/Virtual IP) I should take approval

  • March 26, 2012 at 11:53 pm

    #255398

    Hi,

    I have SQL Server Active/Passive Cluster in which I want to create a database mail for Alerting and Monitoring.I have successfully created it.But my sql server Box ip is not included in Mail server list to allow to send mails.

    I want to take approval to include the SQL Server IP Address in MAil Server list to send mail outside but for which IP(Physical IP/Virtual IP) I should take approval.

    Thanks

  • March 27, 2012 at 12:09 am

    #1464716

    I would say the Virtual IP of the SQL Cluster, as it will be used when failing over.

    Or you could add both node IP's.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • March 27, 2012 at 12:34 am

    #1464726

    Please put your Sureity...

    Thanks

  • March 27, 2012 at 12:41 am

    #1464730

    Granting mail send rights on all three IP's would ensure:

    1. As a cluster, all nodes can send

    2. As single nodes, when the cluster is broken for a reason, can still send.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • March 27, 2012 at 1:39 am

    #1464753

    as its at the virtual instance level that will be sending mail you only need to allow the virtual instance IP address access to the mail server. if you want to be extra careful then as henrico says give the mail server all 3 IP addresses

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply