

So how to use google account as database emailer at MSSQL with new security upgrade? Instead, you’ll need to sign in using Sign in with Google or other more secure technologies, like OAuth 2.0. Today I received mail subjected "You may lose access to some of your third-party apps" saying google is stopping less secure option from 30th May to continue using we need to re login as follows To help keep your account secure, Google will no longer support the use of third-party apps or devices which ask you to sign in to your Google Account using only your username and password. Mail and select "Send Test E-Mail" as shown below. Once your Database Mail profile has been configured you can send test emailsįor validation to verify setup is configured correctly. Sending a Test Email Using SQL Server Database Mail The below table outlines the necessary SMTP server details and port numbers for Confirm Password - Enter password of your Hotmail or Live account.Password - Enter password of your Hotmail or Live account.User Name - Enter your Hotmail or Live account.The server response was: 5.7.0 Must issue a STARTTLS (The SMTP server requires a secure connection or the client This is left unchecked you will encounter this error message, 'The mailĬould not be sent to the recipients because of the mail server failure. The server requires a secure connection (SSL) - check this box.Port number - Enter as shown in screenshot.Server Name - Enter as shown in screenshot.

E-mail Address - Enter your Hotmail or Live account.
