xp_smtp_sendmail connection error
-
Good Afternoon,
I'm using xp_smtp_sendmail to send an internal mail when it comes to database reporting. But 1 day it just stop sending the reports and when I check the sql agent this is the error I saw...
Error: connecting to server 1X.X.X.X [SQLSTATE 01000] (Message 0) Server response: 421 servermail.domain.com connection limit reached
Anyone know how to solve this problem? what is the workaround for this kind of error?
"-=Still Learning=-"
Lester Policarpio
-
Hi,
Check the SMTP Relay Server Settings to which you are connecting.. There is a option in the SMTP Virtual Server to limit the connections and this is what is creating the issue to you...
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc -
Thank you very much for your help!! what values do i need to input in the server where I am connecting? do I need to copy the values in the image you gave?
"-=Still Learning=-"
Lester Policarpio
-
It depends on your SMTP Server and Network Usage.. Leave the values to default which will work for Ideal situation... You can take the help of your System Administrator for proper data 🙂
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply