Post reply

Database Mail Ip

  • April 13, 2011 at 11:06 am

    #238592

    Sorry, I've got a prod issue and can't think straight here. How can I find the SMTP ip that we're using for Database Mail?

    NOTE: This is SS 2005.

    I've looked through the Survace Area Config and Sql Server Config and Mgt Studio and just don't see it...

  • April 13, 2011 at 11:13 am

    #1311195

    the destination mail server? like whatever mail.yourserver.com resolves to? or the ipaddress of the SQL Server Sending the mail to that server?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 13, 2011 at 11:17 am

    #1311197

    I'm looking for the SMTP ip or address that it sends the email to.

    I figured one way to do it. I went into the config wizard for the specific email account that SQL Server uses and pulled it out of there. It seems like you should be able to just run a query and get it or look it up in Mgt Studio without going thru a wizard. Is there an easier way?

  • April 13, 2011 at 11:51 am

    #1311218

    how about nslookup mail.yourserver.com to see what the DNS reverses to, or a ping mail.yourserver.com and see the address it's going to;

    why do you need it's IP vs the DNS name?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 13, 2011 at 12:03 pm

    #1311225

    Sorry - actually, I don't need the ip necessarily and what I gave our win admins was the dns name.

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

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