Mail Setup

Last Post 12 Apr 2007 07:18 AM by sql-tips. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sql-tips
New Member
New Member

--
10 Apr 2007 11:11 AM
I configured a Database Mail in SQL Server 2005. When execute following command in Query Editor
it gives me "Mail Queued". But never receives email nor any error.


sp_send_dbmail @profile_name= 'MyMailProfile',
@recipients='testaddress@Myserver.com',@subject='TEST FROM QUERY EDITOR'
SQLUSA
New Member
New Member

--
10 Apr 2007 02:18 PM
How are you configured?

The emails you are are using must be live!

Kalman Toth
SQL Server 2005 Training - http://www.sqlusa.com/register
SQLUSA
New Member
New Member

--
10 Apr 2007 02:20 PM
The outgoing server must be a live server too....

Did you run TEST in configuration?
sql-tips
New Member
New Member

--
12 Apr 2007 07:18 AM
Yes, I ran test in configuration. It says success, but never receives email. Server is live.
You are not authorized to post a reply.

Acceptable Use Policy