Last post Dec 19, 2008 05:47 AM by parthrawal
Dec 09, 2008 12:10 PM|parthrawal|LINK
I want to send E-mail using database but i am getting Error that Target Machine actively refused it...!?
I am using ArgoSoft as mai server and my port is 25 , argo soft to argo soft it is going but not from database..
so does any body has STEP by STEP guide for it??
any clue ?
Dec 09, 2008 02:44 PM|mudassarkhan|LINK
Use the following stored proc to send email from SQL server 2000
--SendUsing Specifies Whether to send using port (2) or using pickup directory (1)
--Requires Aunthentication None(0) / Basic(1)
-- if you are using html e-mail, use 'htmlbody' instead of 'textbody'.
-- sample error handling.
To call the stored procedure do the following
Depending on your mail settings you can use the above stored procedure to send email using smtp server
Dec 10, 2008 06:24 AM|parthrawal|LINK
Thanks muassar khan,
but i didnt understand a bit, as i am using 2005 + i am using Argosoft Mail server and for SMTP i am using Surface Area Configuration and management studio where i am creating profiles and e-mail account then i am sending Test Mail then in SQL server's Event
log is saying that target machine actively refused it..!!?
can you help me out with this.??
Dec 10, 2008 03:07 PM|mudassarkhan|LINK
Are u using the same stored proc which I gave or something else. If something else what is it?
Dec 17, 2008 09:12 AM|parthrawal|LINK
Thanks man for the reply i am using msdb.dbo.sp_send_dbmail
proceudre for sending mails, and i am using ARgoSoft as mail server for the testing purpose.
Not in the production enviornment.
can you please elaborate more about this please.
Dec 17, 2008 09:56 AM|mudassarkhan|LINK
The bove stored proc works for all smtp servers y dont u try it with ur gmail account
Dec 17, 2008 10:05 AM|parthrawal|LINK
For that i need Live IP address to send E-mail that luxury i dont have it.
if you have any other idea Sir, please do tell me
Dec 17, 2008 10:38 AM|mudassarkhan|LINK
Cant u create a free gmail account. And use that
this stored proc is only for smtp servers.
Dec 17, 2008 01:34 PM|rami_nassar|LINK
no you can't use gmail or any other free e-mail account cause you will not have enough permissions for sending e-mails
Dec 17, 2008 02:30 PM|mudassarkhan|LINK
Ok then send me the details how u use Argosoft mail ie what are the parameters reqd to send email using it
Dec 19, 2008 05:47 AM|parthrawal|LINK
please go to http://www.argosoft.com/RootPages/Download.aspx
download Mail Server Freeware, its easy to configure STEP by STEP configure it and your mail server done.
then i have created a profile in the SQL server with some Services we have to Enable , and try send Test mai to the Users which you have created on Argosoft.