question

mandara avatar image
mandara asked

what are the steps to configure sending email in sql 2000

What are the steps to configure mail in sql 2000 using sql mail? I need the steps for configuring sql mail in 2000.
sql-server-2000database-mail
4 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client. How to resolve it
0 Likes 0 ·
Install Microsoft Outlook on the server, and set it as the default client. Configure a profile in Outlook that SQL Server can use for sending mail. There's no way for SQL Server 2000 to send mail without a MAPI client being installed, unless installing xp_smtp_sendmail extended stored procedure which will send mail using SMTP instead of using MAPI.
0 Likes 0 ·
xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.
0 Likes 0 ·
That's the same comment you already made. Did you try following the advice - install Microsoft Outlook on the server, and configure a profile to use? My other suggestion was to use xp_**smtp_**sendmail which is a 3rd party extended stored procedure that doesn't need Outlook or another MAPI client.
0 Likes 0 ·
Cyborg avatar image
Cyborg answered
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
If you are OK with using extended stored procedures, I would suggest using xp_smtp_sendmail: [ http://sqldev.net/downloads/xpsmtp/default.html][1] [1]: http://sqldev.net/downloads/xpsmtp/default.html
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

mandara avatar image
mandara answered
Hi, Thx for the reply. Is thr any way using entriprise manager i can configure my sql mail in sql 2000 ????????? I need the steeps for that.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
Using SQL Enterprise manager? - check there's a valid MAPI profile - ie, when logged in as the SQL Server service user, can you launch a MAPI client (Outlook, whatever). - Launch SQL Enterprise manager. Navigate down to: - Console Root - Microsoft SQL Servers - SQL Server Group - <<Server_Name>> - Support Services - SQL Mail Right-click, Properties. Select the MAPI profile you wish to use. Then look at [this article][1] for information about making sure the right odds and ends are running. [1]: http://msdn.microsoft.com/en-us/library/ms175189(v=SQL.90).aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.