472,993 Members | 2,649 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,993 software developers and data experts.

SQL Server 2005 Database mail Command not supported (502) SMTP error

Hi all,

At this moment I'm trying to get database mail working. According to
some people it should be easy. Well...that is not the case for me.
I'm having the following error:

The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 2 (2006-11-24T08:48:15). Exception
Message: Cannot send mails to mail server. (Command not implemented.
The server response was: Command not Supported).
)

SQL Server 2005 is installed on a separate server and the SMTP Server
is Lotus Notes. connecting with port 25.

Start and stopping the SQL Server and SQL Server agent i tried already.
i tried sysmail_stop_sp and sysmail_start_sp.

Sometimes when starting or stopping the Mail with the following
commands :

exec sysmail_stop_sp
GO

exec sysmail_start_sp
GO

I will get the following error:

Msg 233, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the
server. (provider: Shared Memory Provider, error: 0 - No process is on
the other end of the pipe.)

So any help would be appreciated.

Hennie

Nov 24 '06 #1
1 5505
Anyone?

Hennie7863 schreef:
Hi all,

At this moment I'm trying to get database mail working. According to
some people it should be easy. Well...that is not the case for me.
I'm having the following error:

The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 2 (2006-11-24T08:48:15). Exception
Message: Cannot send mails to mail server. (Command not implemented.
The server response was: Command not Supported).
)

SQL Server 2005 is installed on a separate server and the SMTP Server
is Lotus Notes. connecting with port 25.

Start and stopping the SQL Server and SQL Server agent i tried already.
i tried sysmail_stop_sp and sysmail_start_sp.

Sometimes when starting or stopping the Mail with the following
commands :

exec sysmail_stop_sp
GO

exec sysmail_start_sp
GO

I will get the following error:

Msg 233, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the
server. (provider: Shared Memory Provider, error: 0 - No process is on
the other end of the pipe.)

So any help would be appreciated.

Hennie
Dec 4 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: ehendrikd | last post by:
hi all i have written a php site that uses the mail() on windows and i had to state in the php.ini file which smtp server to use. have now migrated this site to a redhat 9 server, but i still...
2
by: Mark Carter | last post by:
I'm trying to create a mail server in Twisted. I either get SMTPSenderRefused or SMTPException: SMTP AUTH extension not supported by server. What do I need to do to get it to work?
0
by: John Silver | last post by:
I have a perl script running on machine A, a web server. A visitor completes certain pieces of data and these are compiled into two emails, one addressed to the visitor and copied to the site...
3
by: dale zhang | last post by:
Hi, I write an asp.net web application. It has a “Contact Us” page, where users fill in their email, subject and text and hit send. Then the email will go to my hard coded yahoo email...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
11
by: fdu.xiaojf | last post by:
Hi, I just want to send a very simple email from within python. I think the standard module of smtpd in python can do this, but I haven't found documents about how to use it after googleing....
5
by: Nathan Sokalski | last post by:
I am attempting to send an email using ASP.NET 1.1's Mail.SmtpMail.Send() method. My code contains all of the following: Dim mailmsg As New Mail.MailMessage Mail.SmtpMail.SmtpServer =...
3
by: sachin shah | last post by:
hi all my query is how can i send mail by using sql server, i think by unsing xp_sendmail store procedure we can do this but my problem is what paramater to be pass to this store procedure if i...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
3
SueHopson
by: SueHopson | last post by:
Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.