|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
database mail...can't connect to mailserverHi All: I'm trying to configure database mail in SQL2005 on Windows 2003.
I have configured a public profile, users and SMTP account, but when I send a test email to the mailserver, I get the following error: Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-30T11:36:43). Exception Message: Cannot send mails to mail server. (Failure sending mail.). ) I am able to successfully telnet from the SQL Server to the mailserver and send mail that way. When I try to send database mail, I see it connect to the mailserver, but it never sends the mail. How do I debug this problem? Hi, I'm a Program Manager on the SQL Server Manageability team.
Debugging with DBMail has been exceptionally difficult with SQL Server 2005 RTM and SP1. For SP2, we have added many detailed error messages to help you determine the underlying problems of your configuration instead of generic messages like the one you posted below. I'm personally not sure where to look for more information to help you debug... but if this thread remains unsolved in a few days, I'll try to get somebody from my team to give you some next steps. Paul A. Mestemaker II Program Manager Microsoft SQL Server http://blogs.msdn.com/sqlrem Show quote "geek-y-guy" <no***@nowhere.org> wrote in message news:%23EdtFRGzGHA.4232@TK2MSFTNGP04.phx.gbl... > Hi All: I'm trying to configure database mail in SQL2005 on Windows 2003. > > I have configured a public profile, users and SMTP account, but when I > send a test email to the mailserver, I get the following error: > > Message > The mail could not be sent to the recipients because of the mail server > failure. (Sending Mail using Account 1 (2006-08-30T11:36:43). Exception > Message: Cannot send mails to mail server. (Failure sending mail.). > ) > > I am able to successfully telnet from the SQL Server to the mailserver and > send mail that way. When I try to send database mail, I see it connect to > the mailserver, but it never sends the mail. > > How do I debug this problem? > Paul,
I posted to the sqlserver.server NG the same problem. My message was:- The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-09-01T13:45:00). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for xxxx ) where xxxx is the e-mail address. We can make this work if we set the outgoing SMTP server as our Exchange 2003 server with permission to relay from the SQL2005 server machine. We are not sure that this is what we want so we have SMTP running on the SQL server machine and try to set that as the outgoing SMTP server. This is when we get the error. Thanks Chris Show quote "Paul A. Mestemaker II [MSFT]" <PaulM***@online.micro-soft.com> wrote in message news:e1PgrYgzGHA.4396@TK2MSFTNGP04.phx.gbl... > Hi, I'm a Program Manager on the SQL Server Manageability team. > > Debugging with DBMail has been exceptionally difficult with SQL Server > 2005 RTM and SP1. For SP2, we have added many detailed error messages to > help you determine the underlying problems of your configuration instead > of generic messages like the one you posted below. I'm personally not > sure where to look for more information to help you debug... but if this > thread remains unsolved in a few days, I'll try to get somebody from my > team to give you some next steps. > > Paul A. Mestemaker II > Program Manager > Microsoft SQL Server > http://blogs.msdn.com/sqlrem > > "geek-y-guy" <no***@nowhere.org> wrote in message > news:%23EdtFRGzGHA.4232@TK2MSFTNGP04.phx.gbl... >> Hi All: I'm trying to configure database mail in SQL2005 on Windows 2003. >> >> I have configured a public profile, users and SMTP account, but when I >> send a test email to the mailserver, I get the following error: >> >> Message >> The mail could not be sent to the recipients because of the mail server >> failure. (Sending Mail using Account 1 (2006-08-30T11:36:43). Exception >> Message: Cannot send mails to mail server. (Failure sending mail.). >> ) >> >> I am able to successfully telnet from the SQL Server to the mailserver >> and send mail that way. When I try to send database mail, I see it >> connect to the mailserver, but it never sends the mail. >> >> How do I debug this problem? >> > > Paul,
Relaying to our Exchange server works but trying to send from the actual SQL server machine does not work. We can use SMTP to relay non SQL Database Mail so what is needed to make this work? Thanks Chris Show quote "Paul A. Mestemaker II [MSFT]" <PaulM***@online.micro-soft.com> wrote in message news:e1PgrYgzGHA.4396@TK2MSFTNGP04.phx.gbl... > Hi, I'm a Program Manager on the SQL Server Manageability team. > > Debugging with DBMail has been exceptionally difficult with SQL Server > 2005 RTM and SP1. For SP2, we have added many detailed error messages to > help you determine the underlying problems of your configuration instead > of generic messages like the one you posted below. I'm personally not > sure where to look for more information to help you debug... but if this > thread remains unsolved in a few days, I'll try to get somebody from my > team to give you some next steps. > > Paul A. Mestemaker II > Program Manager > Microsoft SQL Server > http://blogs.msdn.com/sqlrem > > "geek-y-guy" <no***@nowhere.org> wrote in message > news:%23EdtFRGzGHA.4232@TK2MSFTNGP04.phx.gbl... >> Hi All: I'm trying to configure database mail in SQL2005 on Windows 2003. >> >> I have configured a public profile, users and SMTP account, but when I >> send a test email to the mailserver, I get the following error: >> >> Message >> The mail could not be sent to the recipients because of the mail server >> failure. (Sending Mail using Account 1 (2006-08-30T11:36:43). Exception >> Message: Cannot send mails to mail server. (Failure sending mail.). >> ) >> >> I am able to successfully telnet from the SQL Server to the mailserver >> and send mail that way. When I try to send database mail, I see it >> connect to the mailserver, but it never sends the mail. >> >> How do I debug this problem? >> > > Can you use Outlook Express on the SQL Server machine to send mail through
your SMTP server? Are you familiar with .NET? There is an SMTPClient class that you could use to try to send email through your server. You should receive the same error through that and you will be able to debug it. Show quote "Chris Wood" <anonym***@discussions.microsoft.com> wrote in message news:uoq6Vxe0GHA.1268@TK2MSFTNGP02.phx.gbl... > Paul, > > Relaying to our Exchange server works but trying to send from the actual > SQL server machine does not work. We can use SMTP to relay non SQL > Database Mail so what is needed to make this work? > > Thanks > > Chris > > "Paul A. Mestemaker II [MSFT]" <PaulM***@online.micro-soft.com> wrote in > message news:e1PgrYgzGHA.4396@TK2MSFTNGP04.phx.gbl... >> Hi, I'm a Program Manager on the SQL Server Manageability team. >> >> Debugging with DBMail has been exceptionally difficult with SQL Server >> 2005 RTM and SP1. For SP2, we have added many detailed error messages to >> help you determine the underlying problems of your configuration instead >> of generic messages like the one you posted below. I'm personally not >> sure where to look for more information to help you debug... but if this >> thread remains unsolved in a few days, I'll try to get somebody from my >> team to give you some next steps. >> >> Paul A. Mestemaker II >> Program Manager >> Microsoft SQL Server >> http://blogs.msdn.com/sqlrem >> >> "geek-y-guy" <no***@nowhere.org> wrote in message >> news:%23EdtFRGzGHA.4232@TK2MSFTNGP04.phx.gbl... >>> Hi All: I'm trying to configure database mail in SQL2005 on Windows >>> 2003. >>> >>> I have configured a public profile, users and SMTP account, but when I >>> send a test email to the mailserver, I get the following error: >>> >>> Message >>> The mail could not be sent to the recipients because of the mail server >>> failure. (Sending Mail using Account 1 (2006-08-30T11:36:43). Exception >>> Message: Cannot send mails to mail server. (Failure sending mail.). >>> ) >>> >>> I am able to successfully telnet from the SQL Server to the mailserver >>> and send mail that way. When I try to send database mail, I see it >>> connect to the mailserver, but it never sends the mail. >>> >>> How do I debug this problem? >>> >> >> > >  
Other interesting topics
SQL Server 2005 Activity Monitor doesn't show connections from Windows 98 clients
differnt execution plans for same query Import Data succeeds but doesn't copy data? SQL Server 2005 Management Studio vs. 2000 Enterprise Manager/Query Analyzer SIMPLE command to convert string to number? Not CAST or CONVERT. |
|||||||||||||||||||||||
