[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL Server Database Mail

Posted on 2009-05-13
2
Medium Priority
?
866 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
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.

612 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