Post reply

database mail error

  • September 1, 2011 at 5:47 am

    #247227

    Hi folks, hope everyone is well

    I have recently for the first time set up database mail in SQL server 2008.

    However when I test to see if I can send the mail by right clicking databaseMail icon in management studio and selecting 'Send Test EMail'.

    the mail could not be sent to the recipients because of the mail server failure.

    (sending mail using account 1 (2011-09-01T11:10:59)

    Exception message: could not connect to mail server. (an attempt was made to access a socket in a way forbidden by it's access permissions 10.226.1.23:25 )

    Does anyone know what the best ways are to troubleshoot this or has anyone any personal experience with this error.

    I'm in the mind that it's something to do with permissions or SMTP accounts but I don't know enough about SMPT. If it's basic authentication, do I type the username and password of the physical server? Or is there somewhere in SMPT where a username and password is specified that I can use? What other things could I check? (i.e SMTP port number, IP address etc?)

    The folks that are responsible for the SMTP aren't here and I need to sort this out as soon as I can

    Can anyone be so kind to help me?

    Many thanks

  • September 1, 2011 at 6:00 am

    #1375899

    i'd say the issue's what you put for the mail server value..."could not connect to mail server." to me says that the url, say "mail.yourdomain.com is actually something else.

    it seems to me it never made it to the mail server in the first place.

    try this url to help:

    enter the domain name and you will see the address of the mail servers associated to teh domain to use:

    http://www.mxtoolbox.com/

    for example, if i put in "sqlservercentral.com",

    i get results like this:

    mx:sqlservercentral.com mx

    Pref Hostname IP Address TTL

    0 mx1.emailsrvr.com 98.129.185.3 24 hrs SMTP Test Blacklist Check

    5 mx2.emailsrvr.com 72.4.117.22 24 hrs SMTP Test Blacklist Check

    that might help you diagnose the connectivity issue.

    dunno if this will help, but here's how one of my profiles, using Google Mail i sset up:

    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!

Viewing 2 posts - 1 through 1 (of 1 total)

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