Database Mail Configuration

Question

Post reply

Database Mail Configuration

Arthur.Lorenzini

SSCrazy

Points: 2312
More actions
October 14, 2010 at 9:16 am

#239679

Is there a way to configure Database Mail to use either a hotmail or yahoo account. SQL Server 2008 Enterprise Evaluation.
Warm Regards,
Arthur Lorenzini
Sioux Falls, SD

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

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

456789psw SSCarpal Tunnel Points: 4728 More actions · Answer 1

here they say you need a premium account but look at the sec link ...looks like this person found a work around

http://www.sqlservercentral.com/Forums/Topic583905-145-1.aspx#bm585971

http://blogs.msdn.com/b/billramo/archive/2009/03/29/using-live-hotmail-msn-for-sql-server-2008-database-mail.aspx

Lowell SSC Guru Points: 323507 More actions · Answer 2

I've gotten a Gmail account to work just fine; they use an alternate port for SMTP, but the rest was a typical setup:

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!

Arthur.Lorenzini SSCrazy Points: 2312 More actions · Answer 3

Tried both the links but noting worked. Still looking into it.

Warm Regards,

Arthur Lorenzini
Sioux Falls, SD

Johan Bijnens SSC Guru Points: 135272 More actions · Answer 4

did you check your firewall is open for this port number ?

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Arthur.Lorenzini SSCrazy Points: 2312 More actions · Answer 5

I had to re-install my SSMS for another reason and when I setup the database mail in accordance with your advice, it started working!!!!! THANKS!

Warm Regards,

Arthur Lorenzini
Sioux Falls, SD

Marios Philippopoulos SSC Guru Points: 57190 More actions · Answer 6

Run queries below to troubleshoot db-mail issues:

--get failed messages over last 5 days:

SELECT * FROM msdb.dbo.sysmail_faileditems

where datediff (day, sent_date, getdate()) < 5

--get mailitem_id from query above - eg. 2024 - and run below to get full error message (description column):

SELECT * FROM msdb.dbo.sysmail_event_log

where mailitem_id = 2024

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]