SQL 2005 EMAIL DATABASE SET UP

Question

SQL 2005 EMAIL DATABASE SET UP

ian.dunlop-1123241

SSC Enthusiast

Points: 184
More actions
October 23, 2009 at 9:54 am

#138973

HI ALL,
I am trying to set up my SQL server developer edition to use my SMTP bt yahoo account and have had various errors but know seems to stick with..
Date23/10/2009 16:37:36
LogDatabase Mail (Database Mail Log)
Log ID163
Process ID3464
Last Modified23/10/2009 16:37:36
Last Modified ByNT AUTHORITY\SYSTEM
Message
Could not retrieve item from the queue.
I am duplicating my outlook express settings as below..
using port 25 for outgoing mail with SSL unticked
using port 110 for incoming mail with SSL unticked
outgoing mail tick box for SSL required is ticked and using my password and user name.
above settings using outlook express works fine
when I try and send email using the test email it returns the above error.
Have gone round in circles with this - any help or assistance would be great
Kind regards

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

Make sure that you enabled Database Mail in the Surface Area Configuration Tool. Then Open up SSMS, go to SQL Server Agent and right click on it. Go Properties. Go Alert System and check "Enable Mail Profile" ensure it's checked and OK.

ian.dunlop-1123241 SSC Enthusiast Points: 184 More actions · Answer 2

Thanks for your reply - all this is done - when I check i get this message now...

Date23/10/2009 17:10:08

LogDatabase Mail (Database Mail Log)

Log ID175

Process ID2988

Mail Item ID55

Last Modified23/10/2009 17:10:08

Last Modified Bysa

Message

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2009-10-23T17:10:08). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: authentication required - "Your email could not be sent. To fix this you must make a simple change to your email (known as SMTP authentication). For advice visit http://www.btyahoo.com/smtp").

)

:w00t:

Any ideas what is going on?

Kind Regards

ian.dunlop-1123241 SSC Enthusiast Points: 184 More actions · Answer 3

ps - did as it asks and ran a script from the site and made no difference and produced the above

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 4

Try changing the port from 25 to 587. Your ISP could be blocking port 25 or you could have a virus scanner that is blocking that port as well.

Lowell SSC Guru Points: 323546 More actions · Answer 5

outgoing mail tick box for SSL required is ticked and using my password and user name.

i don't think this should be checked...that means use https: or whatever the equivilent is for mail SSL;

if your mails erver does not use it(mine uses SSL port 625 or something, for example) i think that will make it fail.

since you put in the username and password, that is the simple AUTH it was talkinga bout.

see if changing that one checkbox makes the difference.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!