Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 Database Mail Expand / Collapse
Author
Message
Posted Thursday, May 30, 2013 12:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 3:46 AM
Points: 27, Visits: 196
Hi SQL Masters,

I have a situation on my SQL Server hosted on Virtual machine (Oracle Virtual Box). I have a SQL Server there and i configured the Database mail via Wizard and 'Database Mail XPs'. My problem here is that the test mail could not succeed.

Anybody could help on this situation?


Thanks and Regards,

dev1
Post #1458046
Posted Thursday, May 30, 2013 12:28 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:56 PM
Points: 2,397, Visits: 2,936
There is not enough information to help you. Do you have error messages (on screen or in the logging)?
Some common issues:
- firewall
- anti-virus blocking the mail
- incorrect exchange server
- ...
try this link to help you troubleshooting: http://msdn.microsoft.com/en-us/library/ms188663(v=sql.105).aspx


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1458051
Posted Thursday, May 30, 2013 12:34 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 4:14 AM
Points: 709, Visits: 1,430
Check the log for database mail. Is there an error from your test? If so, what is it?

Joie Andrew
"Since 1982"
Post #1458054
Posted Thursday, May 30, 2013 12:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 3:46 AM
Points: 27, Visits: 196
Hi,

The firewall is off and no antivirus installed on this virtual machine. regarding exchange server, i only used smtp.gmail.com



Thanks,

dev1
Post #1458059
Posted Thursday, May 30, 2013 12:47 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:56 PM
Points: 2,397, Visits: 2,936
dev1.bohol (5/30/2013)
Hi,
... i only used smtp.gmail.com


have you read 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 and http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/setting-up-sql-server-database?


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1458061
Posted Monday, June 10, 2013 2:20 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 3:46 AM
Points: 27, Visits: 196
Hi SQL Masters,

Thank you all for your response. It works fine now


Best Regards,

Dev1
Post #1461768
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse