Just Gone through earlier posts and tried.
I successfully created DBMail Setup using smtp.gmail.com,
with basic authentication of my GMail account and password,
Created a profile using a server name : smtp.gmail.com, port : 587.
Then I configured a report server 2005 , (generated a report as Transactions and scheduled to subscribe my GMAIL account) for this profile and tried subscribing to my gmail account.
When i just tried a query through Query Analyzer it shows "Mail Queued". But when i see the DB Mail Log, the error is as:
Date 1/12/2010 12:09:07 PM
Log Database Mail (Database Mail Log)
Log ID 77
Process ID 4192
Mail Item ID 38
Last Modified 1/12/2010 12:09:07 PM
Last Modified By sa
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2010-01-12T12:09:07). Exception Message: Could not connect to mail server. (No such host is known).
Correct me if am wrong in any areas.
My criteria is to get a report server report daily to my gmail account using the SMTP of gmail. So that can configure to my local machine with local internet.
Any suggestions ?
" Have a great day "