Setting Up SQL Database Email with a Google Mail Account

 

If you need to use a Google Account for setting up email notifications on SQLServer make sure you use the 2 step security method.

1. Login to the Google Account
2. Go to Account Settings for the Account – Upper Right when you log in.
3. Select Sign-in and Security

 

4. Then – 2 step

5. Then perform the actions needed to do the verification by phone or text.

6. Next, Add a name for the app “SQL Database Email” etc.

7. Grab the password

8. Configure the DB email account and place the password there for the account authentication (see below)

Hope this helps!