14,494 questions
SQL Server acts as a comon SMTP client, sending a mail to the server and if don't work, then you have a mistake in the configuration.
sql server not sending Gmail
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 45%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
sohrab khan
25
Reputation points
hi every one ,
i have configured SQL server with Gmail to send email from MS SQL Server ,
my server name =smtp.gmail.com
checked (SSL)
port no 587
its configured successfully but when I send email ,it raise:
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2023-08-09T22:03:44). Exception Message: Could not connect to mail server. (No such host is known). )
SQL Server Other
Accepted answer
-
Olaf Helper 47,436 Reputation points2023-08-10T05:28:12.3266667+00:00 -
sohrab khan 25 Reputation points
2023-08-10T05:34:34.4666667+00:00 thank you for your quick response , it was working few days back but its not working now ,i have created both profile and account using SQL server management studio with my gmail account and password using smtp.gmail.com.
-
Olaf Helper 47,436 Reputation points
2023-08-10T06:36:33.2133333+00:00 You mention SSL encryption and port 587; that's wrong, GMail uses port 465 with SSL; 587 is for TLS.
See
-
sohrab khan 25 Reputation points
2023-08-12T05:22:30.4133333+00:00 i have changed port no 465 with SSL, and link you have mentioned i already implemented app password .
-
sohrab khan 25 Reputation points
2023-08-12T06:45:31.6166667+00:00 and also i have implemented
2-Step Verification and app password ,but still shows same error. -
sohrab khan 25 Reputation points
2023-08-17T06:00:53.0166667+00:00 finally ,its work for me ,I have followed your link and its work now .
Sign in to comment -
2 additional answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-08-10T08:57:02.43+00:00 Hi @sohrab khan
Please refer to this document for general database troubleshooting: https://learn.microsoft.com/en-us/sql/relational-databases/database-mail/database-mail-general-troubleshooting?view=sql-server-ver15.
I also found some links to setup database mail in SQL Server using Gmail, you can check if the steps are correct:
https://appuals.com/how-to-setup-database-mail-in-sql-server-using-gmail/.
Hope these can help you.
Best regards,
Aniya
-
sohrab khan 25 Reputation points
2023-08-12T05:30:55.1533333+00:00 thank for your quick response, i follow your links but still the same error.
Sign in to comment -
-
Javier Villegas 900 Reputation points MVP2023-08-10T09:29:00.09+00:00 Hello
Please follow this link. It is working fine for me
https://appuals.com/how-to-setup-database-mail-in-sql-server-using-gmail/