Sql Edition Selection: mail

Showing posts with label mail. Show all posts

Tuesday, March 27, 2012

emails reside in Inbox?

Hi,
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
joujHi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>

emails reside in Inbox?

Hi,
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
jouj
Hi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/default...b;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>

Monday, March 26, 2012

emails reside in Inbox?

Hi,
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
joujHi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/defaul...kb;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>

E-mails are stuck in the outlook

E-mails are stuck in the Outlook

Hi everybody,
When i send E-mails through SQL Mail, they end up in the inbox of MS Outlook
account. Only when i press 'send' mails are sent. I have Microsoft Outlook
2002. I have configured my Hotmail account in it as i don't have MS Exchange.
I have SQL Server 2000 with Service Pack 3. And my machine is windows 2000
with service pack 4. What could be the reason and what are the remedies?
thanks in advance
nomi
You need to leave outlook open. Check Q5 in the following
article:
INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
-Sue
On Thu, 27 Jan 2005 23:15:01 -0800, "nomi"
<nomi@.discussions.microsoft.com> wrote:

>Hi everybody,
>When i send E-mails through SQL Mail, they end up in the inbox of MS Outlook
>account. Only when i press 'send' mails are sent. I have Microsoft Outlook
>2002. I have configured my Hotmail account in it as i don't have MS Exchange.
>I have SQL Server 2000 with Service Pack 3. And my machine is windows 2000
>with service pack 4. What could be the reason and what are the remedies?
>
>thanks in advance
>nomi
>
>
|||Sue,
I have kept Outlook Open, but i still have to press 'send' to send the
e-mails otherwise they are stuck in my inbox.
nomi
"Sue Hoegemeier" wrote:

> You need to leave outlook open. Check Q5 in the following
> article:
> INF: Common SQL Mail Problems
> http://support.microsoft.com/?id=315886
> -Sue
> On Thu, 27 Jan 2005 23:15:01 -0800, "nomi"
> <nomi@.discussions.microsoft.com> wrote:
>
>
|||You can't log off the server either. Log in under the
service account that SQL Server runs under, open outlook and
do not close outlook and do not log out.
If you still have problems, you should switch to Outlook
2000 as there are many issues with using Outlook 2002 or
higher with a non-Exchange mail server. If you loose
connectivity to your Pop3 mail server, even briefly, you can
also have problems.
The solution with the least amount of headaches is to not
use SQL Mail but to use SMTP mail instead. You can find more
information and download an extended stored procedure for
smtp mail at:
http://www.sqldev.net/xp/xpsmtp.htm
-Sue
On Sun, 30 Jan 2005 21:25:04 -0800, "nomi"
<nomi@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue,
>I have kept Outlook Open, but i still have to press 'send' to send the
>e-mails otherwise they are stuck in my inbox.
>nomi
>"Sue Hoegemeier" wrote:

E-mails are stuck in the outlook

Emailing results from query

Hi,
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
Ana
Read about sp_send_dbmail.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test mail without a problem. I
> also managed to create a job which would execute a query. I'd like now the sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-6164310-2.html#Listing%20B
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana

Emailing results from query

Hi,
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
AnaRead about sp_send_dbmail.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test m
ail without a problem. I
> also managed to create a job which would execute a query. I'd like now the
sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-61...tml#Listing%20B
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana

Emailing results from query

Hi,
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
AnaRead about sp_send_dbmail.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test mail without a problem. I
> also managed to create a job which would execute a query. I'd like now the sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-6164310-2.html#Listing%20B
--
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana

Emailing Report

I need to export a view into excel and mail to my manager daily morning. Is there a way i can automate this process. I know how to convert view to excel but i need a better solution to automate this process with emailing to my mgr. Please suggest a better approach of doing this.

Thanks,

The send mail task accepts the use of file attachments.

You are using SSIS, right?|||Or you might want to consider Reporting Services for this.|||

Thats true but how; Firstly i need to convert view to excel and then send excel sheet as attachment in email. Could you pls. explain how i could do this. I am a newbie.

Thanks

|||

If you are going to use SSIS, create a new package, add a data flow task with an OLEDB source that retrieves the view. Add an Excel destination to the data flow to capture the results. Back in the control flow, add a Send Mail task to send the email.

If you want to do it in Reporting Services, post your question in the RS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) and I'll answer it there.

Emailing from MS SQL

Hey,

I would like to set up a job to send mail out to clients on a semi-regular basis. Is there a way to mail directly from MS SQL.

or some application which I can set to interface with MS SQL and send these mails out.

I'm currently using asp.net, however, doing it through the web is very time consuming, I would much rather use some application to generate the mails on the server as it currently takes close to 20 min to send through the web interface (and that's only to 900 members, we are looking at having at least 2000 members in a few weeks). What am I looking for is something I can call perhaps with transact sql so I can run it through an ms sql server job, however any solution you have would be fantastic.

If you don't have specific details, that's fine, I'm not even sure what apps etc to look into, even a name of some technology to use (or does MS SQL have a way of doing all of this itself?)

Thanks a lot for your help, life saver ;-)have you looked at xp_sendmail in the bol??|||lol, arg, it's always something simple.

Awesome, that looks pretty much like example what I want.

Thanks a lot mate ;-)|||So worries, hope it works out for you. I have often wanted to use it but due to server setup and network admins being what they are it's never happened... :(|||it's pretty simple to set up SQLMail
the trick is to get the SQL Server agent a domain user account to use as a startup account. then just set up a user mail profile by logging in as that user account. and opening your client (Isuggest outlook 98 or newer)
it will work with any MAPI1 compatible mail server even so even lotus notes...|||KBA (http://support.microsoft.com/default.aspx?kbid=263556) to configure the SQLMail.|||even so even so even so even so

sorry i was stuck in the inner groove of sgt pepper|||Hey,

I've had a few weeks on another project, and I'm back onto this job again (um, yay?, lol).

Anyway, I have had a look over the KBA link Satya posted. I am unsure if this will solve my problem, so, here are some more details about my situation.

I have a dedicated webserver at Cradle (an internet hosting company in australia).

My machine is isolated from the other machines (I'm not 100% sure about this, but it 'seems' to be the case).

They have a mail server which is something like: host1.xxxxxx.com.au. I need to send my mail through this.

The mail I send, I also need to be able to control the <From> field.

As the user who sends the mail, needs to be the user who the message is <From>, the stuff I've read in the KBA seems to send the mail through a single mail account (correct me if I'm wrong).

Also, I don't have access to Outlook on that machine. Is there some free tool etc I can install, or will I need to ship an old copy of outlook to the server for them to install for me?

Thanks, I'll head back to the KBA and keep reading now, see if I can't try and answer my own questions (fingers crossed)|||If you don't wish to set up SQL Server with a domain account or if you don't wish to use Outlook/Exchange, there are alternatives. I use a stored procedure that just needs a SMTP server to relay mail through that I found here:

http://www.sqlservercentral.com/scripts/contributions/510.asp

You'll have to register with the site to get the script, but it's well worth it. Their script library is VERY impressive.

Thursday, March 22, 2012

email using

hi
can any one guide me, how to send email using stored procedure in sql server
2000 in windows 2003 o/s without using mail client installed on server.
Thanks
KalyanUse xp_smtp_sendmail, all you need is the ability to install an extended
procedure, and an SMTP server you can control.
http://www.aspfaq.com/2403
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:6CF632BE-9936-4E86-8477-297EBEFC952A@.microsoft.com...
> hi
> can any one guide me, how to send email using stored procedure in sql
> server
> 2000 in windows 2003 o/s without using mail client installed on server.
> Thanks
> Kalyan
>|||Aaron
My operating system is windows 2003, Is smtp comes with IIS?
Thanks
Kalyan
"Aaron Bertrand [SQL Server MVP]" wrote:

> Use xp_smtp_sendmail, all you need is the ability to install an extended
> procedure, and an SMTP server you can control.
> http://www.aspfaq.com/2403
>
> "Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
> news:6CF632BE-9936-4E86-8477-297EBEFC952A@.microsoft.com...
>
>|||> My operating system is windows 2003, Is smtp comes with IIS?
IIS has its own SMTP server, so yes, I guess it is compatible. However, you
do not have to have SMTP running on the same server as SQL Server, in fact I
recommend it be separate.

email trigger

Hello

Can you setup a trigger to mail some one when a record is updated in SQL server 2005?

If you can, can anyone help me?

Yes, you can call a extended procedure 'xp_sendmail' in an update trigger. The following article shows an example:

http://msdn.microsoft.com/library/en-us/architec/8_ar_da_1tup.asp?frame=true

sql

Email task - no error - no mail

I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this?

I'm sending email by sript component because in the company I cant send via SMTP...

Do you want to try send by script?

Regards!

|||Yes, I can make a try on it. Please send the script. Thanks.|||

Dhanasu wrote:
I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this?

Perhaps it's getting caught up in a spam filter. Or the SMTP server isn't letting that e-mail through. Have you talked to the server admin?|||

here you have...

Code Snippet

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.Net

Imports System.IO

Public Class ScriptMain

' The execution engine calls this method when the task executes.

' To access the object model, use the Dts object. Connections, variables, events,

' and logging features are available as static members of the Dts class.

' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.

' To open Code and Text Editor Help, press F1.

' To open Object Browser, press Ctrl+Alt+J.

Public Sub Main()

Dim strServer As String = "mail.Grupo.com"

Dim strSender As String = "pedro"

Dim strTo As String = "mswail@.mail.com"

Dim strSenderAlias As String = "Pedro"

Dim strSubject As String = "SUCESS Import CLiq - " & Today()

Dim strBody As String = "OK"

Dim sUri As String

sUri = "http://" + strServer + "/Exchange/" + strSenderAlias

sUri = sUri + "/%23%23DavMailSubmissionURI%23%23/"

Dim myUri As System.Uri = New System.Uri(sUri)

Dim HttpWRequest As HttpWebRequest = CType(WebRequest.Create(myUri), HttpWebRequest)

Dim sQuery As String

sQuery = "To: " & strTo & vbNewLine & _

"Subject: " & strSubject & vbNewLine & _

"Date: " & Date.Now & vbNewLine & _

"X-Mailer: My DAV mailer" & vbNewLine & _

"MIME-Version: 1.0" & vbNewLine & _

"Content-Type: text/plain" & vbNewLine & _

"Charset = ""iso-8859-1""" & vbNewLine & _

"Content-Transfer-Encoding: 7bit" & vbNewLine & vbNewLine & _

strBody

Dim myCred As NetworkCredential = New NetworkCredential("GRUPOCGD\rhs0002", "275007")

Dim myCredentialCache As CredentialCache = New CredentialCache()

myCredentialCache.Add(myUri, "Basic", myCred)

HttpWRequest.Credentials = myCredentialCache

HttpWRequest.Headers.Set("Translate", "f")

HttpWRequest.ContentType = "message/rfc822"

HttpWRequest.ContentLength = sQuery.Length

HttpWRequest.Timeout = 300000

HttpWRequest.Method = "PUT"

Dim ByteQuery As Byte() = System.Text.Encoding.ASCII.GetBytes(sQuery)

HttpWRequest.ContentLength = ByteQuery.Length

Dim QueryStream As Stream = HttpWRequest.GetRequestStream()

QueryStream.Write(ByteQuery, 0, ByteQuery.Length)

QueryStream.Close()

Dim HttpWResponse As HttpWebResponse = CType(HttpWRequest.GetResponse(), HttpWebResponse)

Dim iStatCode As Integer = CType(HttpWResponse.StatusCode, Integer)

Dim sStatus As String = iStatCode.ToString()

myCred = Nothing

myCredentialCache = Nothing

HttpWRequest = Nothing

HttpWResponse = Nothing

QueryStream = Nothing

Dts.TaskResult = Dts.Results.Success

End Sub

End Class

|||I am wiating for the reply from the admin. The from and to addresses are mine, so there are no possibility for Spam filter. If the SMTP is in error I hope I should get error message !!!|||

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

|||

Dhanasu wrote:

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

You mean you used the wrong server?

|||Yes, i was using wrong server.|||

Dhanasu wrote:
Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.|||

Phil Brammer wrote:

Dhanasu wrote:
Yes, i was using wrong server.
But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.

If the SMTP server is invalid, because it will not be able to find that server at all, it wont throw any error for opening the connection I agree. But since its not able to find the server specified in the connection manager, it should throw the error for this right?

Thanks
|||

Karunakaran wrote:

Phil Brammer wrote:

Dhanasu wrote:
Yes, i was using wrong server.
But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.
If the SMTP server is invalid, because it will not be able to find that server at all, it wont throw any error for opening the connection I agree. But since its not able to find the server specified in the connection manager, it should throw the error for this right?
Thanks

When I set it up to point to a server that doesn't exist, I get an error message: "[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.". "

So if the OP above didn't get an error message and the task succeeded, then it must've been a valid SMTP server, just not the correct one.|||

An added question: Since the mail task is directly bind with the SMTP I can send emails from anonymous email as the "from email id". Is this an issue in my server configuration or in SSIS "send task"?

sql

Email task - no error - no mail

I'm sending email by sript component because in the company I cant send via SMTP...

Do you want to try send by script?

Regards!

|||Yes, I can make a try on it. Please send the script. Thanks.|||

Dhanasu wrote:
I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this?

Perhaps it's getting caught up in a spam filter. Or the SMTP server isn't letting that e-mail through. Have you talked to the server admin?|||

here you have...

Code Snippet

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.Net

Imports System.IO

Public Class ScriptMain

' The execution engine calls this method when the task executes.

' To access the object model, use the Dts object. Connections, variables, events,

' and logging features are available as static members of the Dts class.

' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.

' To open Code and Text Editor Help, press F1.

' To open Object Browser, press Ctrl+Alt+J.

Public Sub Main()

Dim strServer As String = "mail.Grupo.com"

Dim strSender As String = "pedro"

Dim strTo As String = "mswail@.mail.com"

Dim strSenderAlias As String = "Pedro"

Dim strSubject As String = "SUCESS Import CLiq - " & Today()

Dim strBody As String = "OK"

Dim sUri As String

sUri = "http://" + strServer + "/Exchange/" + strSenderAlias

sUri = sUri + "/%23%23DavMailSubmissionURI%23%23/"

Dim myUri As System.Uri = New System.Uri(sUri)

Dim HttpWRequest As HttpWebRequest = CType(WebRequest.Create(myUri), HttpWebRequest)

Dim sQuery As String

sQuery = "To: " & strTo & vbNewLine & _

"Subject: " & strSubject & vbNewLine & _

"Date: " & Date.Now & vbNewLine & _

"X-Mailer: My DAV mailer" & vbNewLine & _

"MIME-Version: 1.0" & vbNewLine & _

"Content-Type: text/plain" & vbNewLine & _

"Charset = ""iso-8859-1""" & vbNewLine & _

"Content-Transfer-Encoding: 7bit" & vbNewLine & vbNewLine & _

strBody

Dim myCred As NetworkCredential = New NetworkCredential("GRUPOCGD\rhs0002", "275007")

Dim myCredentialCache As CredentialCache = New CredentialCache()

myCredentialCache.Add(myUri, "Basic", myCred)

HttpWRequest.Credentials = myCredentialCache

HttpWRequest.Headers.Set("Translate", "f")

HttpWRequest.ContentType = "message/rfc822"

HttpWRequest.ContentLength = sQuery.Length

HttpWRequest.Timeout = 300000

HttpWRequest.Method = "PUT"

Dim ByteQuery As Byte() = System.Text.Encoding.ASCII.GetBytes(sQuery)

HttpWRequest.ContentLength = ByteQuery.Length

Dim QueryStream As Stream = HttpWRequest.GetRequestStream()

QueryStream.Write(ByteQuery, 0, ByteQuery.Length)

QueryStream.Close()

Dim HttpWResponse As HttpWebResponse = CType(HttpWRequest.GetResponse(), HttpWebResponse)

Dim iStatCode As Integer = CType(HttpWResponse.StatusCode, Integer)

Dim sStatus As String = iStatCode.ToString()

myCred = Nothing

myCredentialCache = Nothing

HttpWRequest = Nothing

HttpWResponse = Nothing

QueryStream = Nothing

Dts.TaskResult = Dts.Results.Success

End Sub

End Class

|||I am wiating for the reply from the admin. The from and to addresses are mine, so there are no possibility for Spam filter. If the SMTP is in error I hope I should get error message !!!|||

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

|||

Dhanasu wrote:

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

You mean you used the wrong server?

|||Yes, i was using wrong server.|||

Dhanasu wrote:
Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.|||

Phil Brammer wrote:

Dhanasu wrote:
Yes, i was using wrong server.
But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.

Thanks
|||

Karunakaran wrote:

Phil Brammer wrote:

Dhanasu wrote:
Yes, i was using wrong server.
But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.
If the SMTP server is invalid, because it will not be able to find that server at all, it wont throw any error for opening the connection I agree. But since its not able to find the server specified in the connection manager, it should throw the error for this right?
Thanks

When I set it up to point to a server that doesn't exist, I get an error message: "[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.". "

So if the OP above didn't get an error message and the task succeeded, then it must've been a valid SMTP server, just not the correct one.|||

Email Subscription Problem

I have an install of Reporting Services which when trying to send an email based subscription, returns the following error;

Failure sending mail: Retrieving the COM class factory for component with CLSID {CD000001-8B95-11D1-82DB-00C04FB1625D} failed due to the following error: 80040154.

No errors are shown in the RS logs or the events logs.

Does anybody have any ideas what could be causing this?

I don't know what version you are using but when it first came out it was hard for most people to install it but I did not get a hard time because I ignored all Windows questions. So I remember it asking for Exchange server you will use with it, if you did not configure Exchange, SMTP or SQL Server Agent to use for your mail that could be the reason for the error. Hope this helps.|||Thanks for your reply. I've double-checked all the configuration and everything appears fine. :(sql

Wednesday, March 21, 2012

e-mail setup on SQL 2000 std

Hello All,
I am trying to set up e-mail notification, but when I open SQL Server Agent
(Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
Profile.
I have Outlook 2002 (XP) installed on the machine, and I tried configuring a
profile with POP and IMAP account, but no mather what I do, the Mail Profile
is stil outgreyed. I don't have MAPI access from that machine, but according
to some books I refered to it shouldn't be a must.
As I can see, either it should be a MAPI, or I am missing something that
should be installed on SQL server, a component or something like that.
Any ideas?
Thanx in advance,
ZoranYOu have t configure the EMail inBox for the service Account SQL Server
Agent is running on. If this is confugured you will be able to see the
Profile. Anyway, if you want to use another program not relying on MAPI, try
the SMTP_Sendmail which is free of charge :-)
http://www.sqldev.net/xp/xpsmtp.htm
HTH, Jens Süßmeyer.
"Kizetoni" <kizetoni@.mail.ru> schrieb im Newsbeitrag
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||http://www.aspfaq.com/2403
--
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Kizetoni" <kizetoni@.mail.ru> wrote in message
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||Yes! :o)
Aaron, thanx!
I checked the link you sent me, and I understood that I should be logging on
with SQL service account.
Once I did that, I could configure the whole thing!
Thanx again!
Regards, Zoran
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> skrev i en meddelelse
news:%23MjmN8CQFHA.2680@.TK2MSFTNGP09.phx.gbl...
> http://www.aspfaq.com/2403
> --
> This is my signature. It is a general reminder.
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
> "Kizetoni" <kizetoni@.mail.ru> wrote in message
> news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> > Hello All,
> >
> > I am trying to set up e-mail notification, but when I open SQL Server
> > Agent
> > (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> > Profile.
> >
> > I have Outlook 2002 (XP) installed on the machine, and I tried
configuring
> > a
> > profile with POP and IMAP account, but no mather what I do, the Mail
> > Profile
> > is stil outgreyed. I don't have MAPI access from that machine, but
> > according
> > to some books I refered to it shouldn't be a must.
> >
> > As I can see, either it should be a MAPI, or I am missing something that
> > should be installed on SQL server, a component or something like that.
> >
> > Any ideas?
> >
> > Thanx in advance,
> > Zoran
> >
> >
>sql

Tuesday, March 27, 2012

emails reside in Inbox?

emails reside in Inbox?

Monday, March 26, 2012

emails reside in Inbox?

E-mails are stuck in the outlook

E-mails are stuck in the outlook

E-mails are stuck in the Outlook

E-mails are stuck in the outlook

Emailing results from query

Emailing results from query

Emailing results from query

Emailing Report

Emailing from MS SQL

Thursday, March 22, 2012

email using

email trigger

Email task - no error - no mail

Email task - no error - no mail

Email Subscription Problem

Wednesday, March 21, 2012

e-mail setup on SQL 2000 std

e-mail setup on SQL 2000 std

e-mail setup on SQL 2000 std

Sql Edition Selection

Blog Archive

About Me