I have a Gmail Account which is configure on MS-Outlook as ( SQLMail ), I am able to send and recieve the mail of gmail on my Outlook Account.
I want to Use same account for sending database mail also. I have configure the database mail by this account. I have done the below setting
Account Name : SQLMAil
After completing all the Setting i get OK and confirm Report , NO Error come till now.
Now when i Send Test mail by usin SQLMail as " Database Mail Profile " i got the Following Error
Date 5/31/2010 12:07:50 PM
Log ID 67
Can you please help me out excatly where is the problem...
Thanks in Advance to all of you
I have never done this (or even thought about doing it) but, assuming you are using SQL 2005 or later, it seems microsoft have had requests from various people as there is an msdn blog about it at http://blogs.msdn.com/b/suhde/archive/2009/07/12/how-to-configure-sql-server-database-mail-to-send-email-using-your-windows-live-mail-account-or-your-gmail-account.aspx.
If you are still using SQL 2000 (this could be a good reason to upgrade) you are probably suffering with security issues over the SQL service account not having access to the Outlook account you have created.
Hope this helps.