.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

configure sql server to receive email.

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


is there any way to configure sql server 2005 or 2008 to receive emails ?

thanks in advance


View Complete Post

More Related Resource Links

Configure Incoming Email in SharePoint 2010 with a remote (public) SMTP Server

I have a standalone SharePoint 2010 Installation on my local network. Have configured the SMTP Services and a SMTP domain called "internalcompany.com". Created a hosts file entry also for that - now outlook is able to send emails to this domain; it reaches the drop folder and from there SharePoint picks it up and pushes to the document libraries. So far so good. But obviously this is not what I want to do: my www.company.com is my public domain and mail server is mail.company.com - how do I get the local SMTP point to this address - so that if someone sends an email to shareddocs@company.com (just like any other normal id), it comes to my local server and then SharePoint. How do I do this? Remember, my server is standalone and my network is not domain based and does not have exchange.Karthick

Send Email from SQL Server Express Using a CLR Stored Procedure

One of the nice things about SQL Server is the ability to send email using T-SQL. The downside is that this functionality does not exist in SQL Server Express. In this tip I will show you how to build a basic CLR stored procedure to send email messages from SQL Server Express, although this same technique could be used for any version of SQL Server.

If you have not yet built a CLR stored procedure, please refer to this tip for what needs to be done for the initial setup.

send email using Godaddy server by gmail


 Hello ,


My site is hosted  in Godaddy server. And i am using google apps for emailing a/c for that i have changed the  MX-records and then it is working fine.

Then i finished my web site


it is working fine there .

in the site there is a  contactus link which opens


this page basically should send a mail to a particular email id .

for sending mail I am using gmail a/c . (Here is the full code)


public void SendEmail(string From,string GmailEmail, string GmailPassword, string To, string Subject, string Body,      
        FileUpload fileupload)

        System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage();
        mail.From = new MailAddress(From, "One Ghost", System.Text.Encoding.UTF8);
        mail.Subject = Subject;
        mail.SubjectEncoding = System.Text.Encoding.UTF8;

Sending Email by exeucting a stored proc on SQL Server that references CLR

Hi Guys, I want to modify the data type of the @body variable in the stored procedure that sends an email. The stored procedure is as follows:   CREATE PROCEDURE [dbo].[spSendMail4]<br/> @recipients [nvarchar](4000),<br/> @cc [nvarchar](4000),<br/> @subject [nvarchar](4000),<br/> @from [nvarchar](4000), @body [nvarchar](4000), @attachment [nvarchar](4000)<br/> WITH EXECUTE AS CALLER<br/> AS <br/> EXTERNAL NAME [SMTPCLR].[StoredProcedure].[spSendMail]<br/> GO   I want to change the @body variable to data type: text. The reason for this, is because I am sending an HTML email whose content (characters) exceed 8000. Basically the new stored procedure should looks like below:   CREATE PROCEDURE [dbo].[spSendMail4] @recipients [nvarchar](4000), @cc [nvarchar](4000), @subject [nvarchar](4000), @from [nvarchar](4000), @body text, @attachment [nvarchar](4000) WITH EXECUTE AS CALLER AS EXTERNAL NAME [SMTPCLR].[StoredProcedure].[spSendMail] GO   If attempt to make this change, I get the below error:   CREATE PROCEDURE for "spSendMail" failed because T-SQL and CLR types for parameter "@body" do not match.   Understandably so, because from the article http://msdn.microsoft.com/en-us/library/ms131092%28SQL.100%29.aspx CLR data type (.NET Framework) is not compa

C# , Sending email through exchange server?

I've searched on this and tried several methods using System.Net.Mail but I can't get it to work. I want to send email using the Exchange server they have at work. Anyone could show me how to do this (server requires authentication)   Thanks in advance

How should I configure Asp.NET on IIS 6, Sql Server 2005 and SSRS 2005 across 2 Windows Server 2003

I was running a MIS reporting solution on a single server running MS Windows 2003 Server and Sql Server 2005. The solution was built using ASP.NET 2.0 on IIS 6.0, Sql Server DB & SSRS. I now have purchased a 2nd server running MS Windows 2003 Server and Sql Server 2005. What is the best configuration to split the following application components across the 2 physical servers? ASP.NET web application SQL Server 2005 Datawarehouse SSRS Web Applications (Reports & ReportServer) SSRS Databases (ReportServer & ReportServerTempDB) The hardware configuration of the 2 servers are as follows Server 1 MS Windows Server 2003 Enterprise Edition SP2 Intel(R) Xeon(R) CPU 5150 @2.66GHz 16 GB RAM Sql Server 2005 SP3 Standard Edition Smart Array P400 in Slot 1 (SAS Array A with Spare / SAS Array B with Spare) Drive C: 68.33 GB | Drive D: 273.40 GB Server 2 MS Windows Server 2003 Standard Edition SP2 Intel(R) Xeon(R) CPU X5570 @2.93GHz 4 GB RAM Sql Server 2005 SP3 Standard Edition IBM ServeRAID-MR10i SAS/SATA Controller Drive C: 135GB | Drive D: 556 GB | Drive E: 271 GB Any suggestions would be of great help

SQL Server Tables and Exchange Web Services sample does not include email body

I've sucessfuly implemented the above, very useful example. However, I cannot work out how to include the Body of the email with the reast of the data. Can anyone shed some light for me? Thanks Robert

Trying to email through SMTP on server 2008

I have the following form and trying to click a button and email through an SMTP server. Any suggestions? Thanks.<table class="style1" bgcolor="#003366" cellpadding="3" cellspacing="3"> <tr> <td class="style2"> Your name:<br /> <asp:TextBox ID="txtHDName" runat="server" Width="161px"></asp:TextBox> <br /></td> </tr> <tr> <td class="style2"> Your email:<br /> <asp:TextBox ID="txtEmail" runat="server" Width="161px"></asp:TextBox></td> </tr> <tr> <td class="style2"> PC name:<br /> <asp:DropDownList ID="DropDownList1" runat="server"> </asp:DropDownList> </td> </tr> <tr> <td class="style2"> Problem:<br /> <asp:DropDownList ID="DropDownList2" runat="server" Width="128px"> </asp:DropDownList> &l

Sending an email with a link that verifies an id in sql server

I have an online job application program that the user fills out and submits the information to our database and on the last page they give there email address so that we can send them an email that has a link that is associated with the ID that's autogenerated by the sql server database when the user submits the information, when the link is clicked it verifies to the database to keep the information submitted by that user per their autogenerated ID. Below is the code that i've written to send the email I have the link setup to go to yahoo right now but I am not sure how to get this to send the autogenerated link that is associated with the ID that is autogenerated already in my sql server database.Private Sub SendMail()        Dim emailSender As SmtpClient        Dim theMessage As MailMessage        Dim EmailAddress As String = txtEmailAddress.Text        emailSender = New System.Net.Mail.SmtpClient("ppicom")        theMessage = New MailMessage        theMessage.From = New MailAddress("PeerlessProductsInc @mail.com")        theMessage.To.Add(EmailAddress)        theMessage.

windows server with sharepoint incoming email

Hi all... I need to configure incoming email in sharepoint but I didn't configure the smtp email in server2003 how can i confiure email without active directory , I need to use email to recieve email in sharepoint but sharepoint didn't connect to active directory , it connect to form authentication (users in sql DB) so please, what's steps? Thanks

Is it possible to configure sharepoint to use active directory service configured in another server

I installed sharepoint in a computer which is not configured as a domain,I want it to use the active directory services in the domain which is another computer

Configure Sharepoint For File server Technology

hi . I want to use sharepoint as movie and picture Archive . Sharepoint Save all data in SQL Server DB . But this not good for my System because My movie file is so larg and so much . I want Save Pic and Movie in File server . please guide me . if any one have a good idea to implement this project , I get Happy to guide me . thanks .  

How to configure SQL Server 2008 R2 Reporting Services for SSL offloading

Hi How to configure SQL Server 2008 R2 Reporting Services for SSL offloading? I found steps for SQL Server 2005 Reporting Service here http://technet.microsoft.com/en-us/library/ms345223(SQL.90).aspx . Will this steps work for 2008 R2 also?  Thanks

Can I upload email back to server

When I setup outlook to a re-formated computer at home. Outlook connected my personal email provider's server and automatically downloaded email, meanwhile removed all my email in the server!!! This is horrible function! I know that I should do advance setting and choose "leave email in sever" before finish. Dose anyone know that I can up load email back to server then I can access the email from other computer?   I really don't understand why Microsoft office has so many auto function, especially why I need to go to advance setting to avoid email delete!!!!!!!! Thanks,       

How to deploy and configure ssis packages using sql server table in testing server and production en

Hi We have three environments (development, testing and production ) I have to configure and deploy the ssis packages using sqlserver table in different environments(development, testing and production).   Three environments database structures  are same But database names are different like (DEVSERVER,SITSERVER,UATSERVER) We have 14 packages and one master package. In master package we called all 14 packages question1 First time i will deploy all (master and 14 packages). If i modify one package we need to deploy all the packages or single package deployment is enough    Please help me thanks in advance          

Want to configure Report server to use SSL

hi... I am running SQl 2005 Reporting services, with default port 80 http://localhost/reports now i want to configure it Https://localhost/reports please help in what step i need to take.. what changes need to be done in IIS and As well as SQl... I Alrady have a SSL Certificate.....    

incoming email on WSS 3.0 in a standalone server environment


Hello Everyone, I have a windows SBS 2008 with exchange 2007 and WSS 3.0 2007 all on one server.

My problem is as follows, I have been trying to set up incoming email inside of wss 3.0, but every guide, blog, and wiki says I need to have SMTP installed, I however cannot have this installed with my configuration. I have created a exchange send connector, created a drop folder, and when I try to email a document to a document library, I get a failure in exchange as follows:

Diagnostic information for administrators:


Generating server: SCS01.scs.com

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