.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Database mail configured, but mails not getting send?

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server

I've configured Database mail, but mails are not getting sent. Checked BOL & various blogs and forums, I'm performing correct steps, using correct smtp server name & port.


DM mail log says: 

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 19 (2010-10-22T07:24:21). Exception Message: Could not connect to mail server. (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond <IP_ADD>:25).


On restarting SQL Agent, log says:

[355] The mail system failed to initialize; check configuration settings

[260] Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail configuration information could not be read from the database. ---> System.Data.SqlClient.SqlException: profile name is not valid

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStre)


View Complete Post

More Related Resource Links

Modify Subject line of Notification e-mails sent by Database Mail

Hello All, I am using database mail for SQL Server Agent Job notification.  It is working just great. However the e-mails that I receive have a specific format of subject line as below. SQL Server Job System: 'TEST' completed on \\Server_Name I wanted to see if I can modify this to send e-mails with this subject line. SQL Server Job System: 'TEST' completed on <Server_Name> Is this possible?  If so can someone help me with the steps? Thanks.

Toolbox: Create Graphs, Send E-Mail, Spell-Check, and More


Turn boring data into stunning graphs, create, parse, send, and receive mail messages from code, and more.

Scott Mitchell

MSDN Magazine August 2007

SQL and Outlook: Enable Database Access and Updates Through Exchange and Any E-mail Client


Using Microsoft technologies, you can insert, edit, query, and delete database entries using any e-mail client such as Hotmail, Outlook, Yahoo, or even WAP phone. While e-mail is certainly a powerful and widely used tool, it is usually not integrated with an application for performing any tasks other than sending reminders. The application scenario described here, an e-mail-based SQL update program, uses a simple data model; however, this solution will apply to any data model that you are working with. It will also eliminate the need for complex n-tier Internet applications and serves as a low maintenance solution for providing data access.

Alok Mehta and Daniel Williams

MSDN Magazine January 2002

I cannot send mail using gmail smtp server


 Here is my code

Dim message As System.Net.Mail.MailMessage = New System.Net.Mail.MailMessage()
        message.To.Add("from textbox field")
        message.Subject = "Testing"
        message.From = New System.Net.Mail.MailAddress("sender email ")
        message.Body = "Just Testing"

        Dim smtp As System.Net.Mail.SmtpClient = New System.Net.Mail.SmtpClient()

        Dim client As SmtpClient = New SmtpClient()
        smtp.Credentials = New System.Net.NetworkCredential("username", "password")
        smtp.Port = 25
        smtp.Host = "smtp.gmail.com"
        smtp.EnableSsl = True
        smtp.DeliveryMethod = SmtpDeliveryMethod.Network
        lblmsg.Text = "Your Email has send"


create Scheduled Task that auto send mails


hello every one

i bought a hosting plan that allows me to send about 500email/per hour

but my client wish to send about 2000 or 3000 email at a time

is there a way to split them and 500 email per a time automaticly without the need of reloging again every hour

my hosting plan doesn't allow me to create a sql jop or send mails via Sql Server.

any bright ideas ?

How to send mail to individual users.



  I need to send the same mail to multiple users separately. I dont want to use comma delimeted "To Address" . Because other users can able to see the recipients.

   Each recipient should not know about the other recipients. 

   How will I achieve this one without for loop ?


send mail don't run

Dim strFrom = "NewsLetter@Kinesiologiaviva.it"             Dim strTo As String = String.Empty             Try                 Dim conn As SqlConnection                 Dim cmd As SqlCommand                 Dim cmdstring As String = "SELECT * FROM vw_MLDestinatari Where [NomeCont]='" & TxtGruppo.Text & "'"                 conn = New SqlConnection(SqlDataSource1.ConnectionString)                 cmd = New SqlCommand(cmdstring, conn)                 conn.Open()                 Dim myReader As SqlDataReader                 myReader = cmd.ExecuteReader(Data.CommandBehavior.CloseConnection)                 While myReader.Read                     strTo &= myReader("Mail") & "; "                 End While            &n

How do I send mail using C#?

Does anyone have a code snippet that shows how to send mail from c#?

How to send E-mail through web site........???

Dear All,    help me in this problem....  "there is one forgot password module in my website.. whenever user click on "forgot password" link then one mail with password directly sent on his email address.." i dont know how do ,, so, help me in this problem...   Thanks, PIYUSH

does SPD support filtering of the mail title/body we send to a list/library?

for example, if we send a mail with the title of "%hostname% %ipaddress%" to a list. can SPD WF filter the title and get %hostname% to a new variable? the reason to ask this is i want to send a well-formated mail to sharepoint and the automatical WF can recognize the change of the list items and update the relevant columns by the filtered content from mail title or body. thanks!

Send E-mail with attachment with workflow

I use workflow in custom list. When new item is created and have attachment. An e-mail is send with attachment. I can not add attachment, or I don’t know how to do that with lookup. I can add link with ID of newly created item, which is ok. But I would like to add attachment directly…Borut

Best way to send data to report server from merge replicated database

Hi ALL,              I have merge replication configured on database say Testdb on production server. I want data from testdb(merge replicated) database to send to report server. How can i accomplish this....Whts the best way to send data at regular intervals to report server.. Any suggestions plz TIA

Mail not send

Hi,In my site, when user submit a form records will send to admin. it is working fine in local machine. but in my server it's not working. it throwing the exception as Could not find file 'C:\Windows\SysWOW64\inetsrv\Tulips.jpg'. I'm using smtp.gmail.com as smtp server and provided network authentication.

SSIS 2005 - Send Mail Task - signature appended to email is garbled - unicode problem?

Hi, I'm pretty new to SSIS so go easy on me. I have a Send Mail Task to notify if a file cannot be imported - the mailbody is created on the previous step by a VB.NET script task to include the name of the file and the path it's been archived to. The problem I'm having is that while the body of the email I've created is displaying fine, our company's Exchange server appends a signature to all emails, and this is coming up as undisplayable characters, presumably due to some kind of unicode encoding problem. I've tried casting the email body in an expression to DT_STR (doesn't work as DT_STR "cannot be converted to a supported type" which seems a bit odd but never mind), DT_WSTR (garbled signature), DT_TEXT/DT_NTEXT (strange error on this one - "Attempted to read or write protected memory") none of those ideas worked, and I'm a bit stumped now. Can anyone help? I'm using SSIS 2005 with SP3

send records as weblinks through send mail task in SSIS?

Hi All, i have a table with two columns and two records as follows. TypeOfReport                       Links InvalidRecords                http://ReportInvalid MissingRecords               http://ReportMissing --------------------- I have a package with execute sql task selecting * from the table above, full result set selected and an object variable created, it works good. but now when i connect it with send mail task, i wanna send email like Subject : Reports On InvalidRecords and MissingRecords MessageText : Links for the Reports : http://ReportInvalid                                                     : http://ReportMissing Can somebone help me with it. NOTE : i tried creating user and object variable but its good if i have only one record in table. i tried creating 2 user and 2 object variables as well but didnt work. Thanks

How to send an email to a website and enter it into the database

Is there a way to send an email to a certain email address and have the message inserted into a database?  The subject would be intered into "Subject" table field and the message body would be inserted into the "Message" table field.Thanks.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend