Post reply

DBMail

  • July 5, 2010 at 4:04 am

    #223487

    Hi all

    Is IIS required for DBmail to work? Our network team have set up and configured a SMTP server and I have tried to configure DBMail to use this server however its failing with:

    Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for xxxx@xxx.com

    I had thought that IIS needed to be configured to allow the local DB server to act as a relay to allow this to work but they are not very keen at all to install SMTP on the server.

    Thanks

  • July 5, 2010 at 6:11 am

    #1188754

    because you are getting responses form the mail server, you have everything set up almost perfect.

    in order to prevent spam, most mail servers prevent relaying(returning error 5.7.1 Unable to relay instead) unless one of two things have happened:

    1.the email used the AUTH command to send the username and password of the account that will do the relaying...you probably have left the defaul "anonymous" selection, or

    2. the mail server is set to relay from a specific IP address(ie all email originating from the web server is allowed)

    change your mail set up to pass the username and password with "basic authentication" instead of "anonymous authentication":

    Kwisatz78 (7/5/2010)

    Hi all

    Is IIS required for DBmail to work? Our network team have set up and configured a SMTP server and I have tried to configure DBMail to use this server however its failing with:

    Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for xxxx@xxx.com

    I had thought that IIS needed to be configured to allow the local DB server to act as a relay to allow this to work but they are not very keen at all to install SMTP on the server.

    Thanks

    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!

  • July 5, 2010 at 11:27 pm

    #1188926

    These link might help you

    http://www.sqlserverclub.com/articles/how-to-set-up-database-mail-on-sql-server-2005.aspx

    http://www.sqlserverclub.com/articles/how-to-set-up-database-mail-on-sql-server-2005-part-2.aspx

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • July 7, 2010 at 3:36 am

    #1189496

    Put simply: No IIS is not required. Just a SMTP server of some description is required.

    Your network team should be able to sovle your issue, its just a matter of relaxing the security rules on the SMTP server.

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

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