x

Configure Database Mail...

Dear All,

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
Description : Test MAil
OutGoing mail Server (SMTP)
Email Address : mohd.basit@gmail.com
Display Name : mohd.basit@gmail.com
Reply Email : mohd.basit@gmail.com
Server name : smtp.gmail.com Port No : 465

SMTP Authentication

Basic Authentication
User name : mohd.basit@gmail.com
pasword : ******
confirm : ******

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 Database Mail (Database Mail Log)

Log ID 67
Process ID 532
Mail Item ID 18
Last Modified 5/31/2010 12:07:50 PM
Last Modified By sa

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 6 (2010-05-31T12:07:50). Exception Message: Cannot send mails to mail server. (The operation has timed out.). )

Can you please help me out excatly where is the problem...

Thanks in Advance to all of you

Basit Khan

more ▼

asked May 31, 2010 at 04:04 AM in Default

Basit gravatar image

Basit
82 7 7 7

I have done some layout changes to your question but you might want to edit it and remove your email details, just to stop any bots scanning it and starting to spam you.
May 31, 2010 at 06:52 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered May 31, 2010 at 07:00 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

Thank you...........
Jun 01, 2010 at 12:49 AM Basit
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x29

asked: May 31, 2010 at 04:04 AM

Seen: 1858 times

Last Updated: May 31, 2010 at 06:50 AM