Re: database mail...can't connect to mailserver

Tech-Archive recommends: Speed Up your PC by fixing your registry

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]" <PaulMest@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:e1PgrYgzGHA.4396@xxxxxxxxxxxxxxxxxxxxxxx
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" <noone@xxxxxxxxxxx> wrote in message
news:%23EdtFRGzGHA.4232@xxxxxxxxxxxxxxxxxxxxxxx
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?





.

Relevant Pages

  • Re: Intersite Communications
    ... mailserver it should go via SMTP, ... server) - they communicate via X.400/MTA...). ... Sydney and one called Melbourne... ... e-mail to Melbourne 2003 via SMTP? ...
    (microsoft.public.exchange.connectivity)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)