Improve company productivity with a Business Account.Sign Up

x
?
Solved

SQL Server Database Mail

Posted on 2009-05-13
2
Medium Priority
?
867 Views
Last Modified: 2012-05-06
I had Database Mail working in a test environment and then got reassigned to other tasks for 6 months. I cannot get it to work now. I have tried a number of things with no success.

The suspicious items I see are:
sysmail_help_queue_sp shows for queue_type status = "INACTIVE"

Also, I am showing the following error message:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2009-05-13T10:19:49). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it 192.168.100.1:25). )

Any help?
0
Comment
Question by:yonbret
2 Comments
 
LVL 6

Accepted Solution

by:
bull_rider earned 2000 total points
ID: 24378351
Can you check this link where I have mentioned various measures to deal with this problem. This might resolve your issue.

http://www.experts-exchange.com/Software/Server_Software/Email_Servers/Exchange/Q_24398908.html

Let me know if it still does not solve your issue.
0
 

Author Closing Comment

by:yonbret
ID: 31581127
I finally found the problem. My virus scan software on the SQL Server was blocking the messages. I disabled the Virus Scan software and it is now working.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question