April 28, 2016 at 6:48 am
I was able to send mail once but do not remember settings. Now any of the following settings I change, it gives the same error.
Sending Mail using Account 6 (2016-04-28T17:47:51). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
The changes I have already tried are as follows:
1. Tried different email providers. yahoo and gmail. and different accounts for each provider.
2. Different combinations of "requires SSL" with various port numbers, 25, 465, 587.
3. Deleting and recreating profiles and accounts in SQL Server.
4. Have tired giving wrong password for the email account.
5. Wrong smtp address of google.
6. Have tried multiple accounts of different email providers in same profile, for instance, 2 of gmail and 1 of yahoo.
Still, it gives the same message mentioned above. Appears something wrong within SQL Server, but, I am not able to figure out.
Initially I was was able to reach to a point where google blocked the attempt since it was from "not so secure client" and wanted me to use "more secure client" like gmail to access my emails in google account.
Then I I turned off "secure apps" in google settings and was able to receive test message from SQL server.
But, after that, I am not able to remember what changes I made that it continues give this error message every time.
Sending Mail using Account 6 (2016-04-28T17:47:51). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
Note: The account number keeps incrementing as I create new account for database mail.
Any help or suggestion is appreciated.
Thanks.
April 28, 2016 at 7:54 am
Gmail is port 587 or 465 try both.
So Email address should be your gmail address.
Server name should be smtp.gmail.com
Check the SSL check box
Under authentication click basic and then enter your gmail username (ensure to include @gmail.com) and password
Try that and let us know the outcome.
April 28, 2016 at 8:14 am
Thanks for your time and effort..!!! Appreciate it..!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply