Post reply

Database Mail - 5.5.1 Authentication Required

  • December 1, 2008 at 10:55 am

    #905769

    Sorry, two more:

    select * from sysmail_profileaccount

    select * from sysmail_principalprofile

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • December 1, 2008 at 10:57 am

    #905773

    OK, so far everything looks OK. The only odd things that I noticed were the port 587 and [enable_ssl]=1 settings on your gmail.smtp server. I assume that both of those are correct? You may want to try disabling the SSL and see if it makes a difference.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • December 1, 2008 at 11:46 am

    #905820

    Hi,

    Both of those are correct... I must've read hundreds of posts by now....

    I've already tried without ssl... and changing the port. But they're correct. Like I said, the settings are most probably ok.... It's got to be something else..

    Thanks for your time.

  • December 1, 2008 at 12:20 pm

    #905846

    rbarryyoung (12/1/2008)

    Sorry, two more:

    select * from sysmail_profileaccount

    select * from sysmail_principalprofile

    Were you able to get these yet?

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • December 1, 2008 at 12:29 pm

    #905854

    profile_id account_id sequence_number last_mod_datetime last_mod_user

    ----------- ----------- --------------- ----------------------- --------------------------------------------------------------------------------------------------------------------------------

    2 1 1 2008-11-30 20:26:03.797 AMY-TOSHIBA\Amy

    (1 row(s) affected)

    profile_id principal_sid is_default last_mod_datetime last_mod_user

    ----------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------- ----------------------- --------------------------------------------------------------------------------------------------------------------------------

    2 0x00 1 2008-11-30 20:49:21.310 AMY-TOSHIBA\Amy

    (1 row(s) affected)

  • December 1, 2008 at 12:35 pm

    #905859

    Well that looks OK too.

    I am afraid that I've reached the limits of my expertise. I would suggest taking a look at the Security & Network settings on the system. I know that it worked for your C# app, but it still looks an awful lot like a firewall or other blocking security issue.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • December 1, 2008 at 1:09 pm

    #905890

    oh well, thanks anyway

  • March 17, 2009 at 4:06 pm

    #961459

    Any luck with this? I am facing the same issue.

  • March 17, 2009 at 5:57 pm

    #961509

    Hi Sam,

    I think gmail is just blocking use via potential spamming.... I cannot find any other explanation. I guess for the people for whom it worked it is before they blocked it? Not sure...

    Good luck

  • September 11, 2009 at 1:47 am

    #1052114

    Hi, I just met this problem.

    I checked anything in the config but did not find the reason.

    but after I added the port 587 to the exception on the ms firewall, the mail worked.

  • August 19, 2011 at 1:10 pm

    #1370958

    Make sure 1) the network you are sneding from is allowed to relay smtp by "smtp.gmail.com". 2) you have no firewall filtering the port traffic to the destination host/port.

    It works for us.

    Regards,

    Jason

    http://usa.redirectme.net

    Jason
    http://dbace.us
    😛

  • August 25, 2011 at 5:42 am

    #1373052

    good

Viewing 12 posts - 16 through 26 (of 26 total)

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