.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 SMTP Connection Manager

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


i have problem with SSIS, Send Mail Task.

What the difference between Send Email using Database Mail and Send Mail task?

Because with Database Mail i can send test email successfully. And can get email using msdb.dbo.sp_send_dbmail.

But when i type SMTP Server on SMTP Connection Manager i get error.

Sending duration is ~10 seconds and error: Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: "Failure sending mail.  System.Net.WebException: Unable to connect to the remote server  System.Net.Sockets.SocketException: 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]."

It maybe problems because of firewall? But why i can send email through Database Mail?

View Complete Post

More Related Resource Links

Going Places: How Connection Manager Connects


Marcus Perryman explains the correct use of Connection Manager when a Windows Mobile application requires network data.

Marcus Perryman

MSDN Magazine December 2008

Configure a module through IIS Manager?


I've developed a custom module with a custom configuration section.  Is there a way to create a plug-in or module so IIS Manager can manage the module?  I'm looking for the ability to enable or disable it by site as well as setup various configuration properties.

Excel Connection Manager Problem

I am building a package that has 2 tasks that need to use the same excel connection manager. I use a execute sql task to dynamically build a table from the headers of the excel sheet  ,then I use an excel source component to load the data from the sheet. However when I try to edit the excel source and switch the data access mode to a variable and select the variable(for the path), when I try to close the editor I get this message 'S:\myfolder'.  It is already opened exclusively by another user, or you need permission to view its data. I need this package to access the same folder each time because the files will be placed in that folder. This package also has a branch for loading a text file into sql server. It access the same folder but uses a flatfile connection manager It looks like permissions on the folder are correct

SQL Server Configuration Manager: Connection to target machine could not be made in a timely fashion

I have a SQL Server 2005 box that was moved from a domain environment to a non-domain environment and was never dropped from its original domain before moving over.  Subsequently a new domain was created at the data center this SQL Server box now resides in.  The machine was dropped from its old domain and joined to the new one.   All the while the service accounts were set to the local admin account.  When I tried to start the Configuration Manager I got the message "Connection to target machine could not be made in a timely fashion.".  I read some blog entries and tried changing all the service accounts to Local System and the error message still came up.   All of the SQL Server services run fine.  It is just this management console that I cannot open.  I wasn't with this employer when this box was moved to the data center so I do not know if it worked prior and there isn't anyone here that could give me its history.   Any help would be appreciated.

errorCode=-1073573417 description=No connection manager is specified.

Hi again,It's me once again trying to migrate a dabatabase from SQL 2000 to SQL 2008 x64. During the migration of one of my databases I get the following error:OnError,LISSQLTEST3,SQLServices,LISSQLTEST2_LISSQLTEST3_Transfer Objects Task,{3CF1D4C8-28CB-4B82-B405-A261E0A173BE},{221EA3F0-32E2-412D-BFDE-76AD1D1715A0},16/08/2009 11:53:07,16/08/2009 11:53:07,0,0x,ERROR : errorCode=-1073573417 description=No connection manager is specified. helpFile= helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}StackTrace:    at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()   at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()   at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()OnError,LISSQLTEST3,SQLServices,CDW_LISSQLTEST2_LISSQLTEST3_15(atashtiot),{E47ED1C2-0D25-48D2-9B4F-14A5DAF96F0A},{221EA3F0-32E2-412D-BFDE-76AD1D1715A0},16/08/2009 11:53:07,16/08/2009 11:53:07,0,0x,ERROR : errorCode=-1073573417 description=No connection manager is specified. helpFile= helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}StackTrace:    at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()   at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()   at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsi

The SMTP server requires a secure connection or the client was not authenticated.........

i am using asp.net & have a emailing modulewhen i use gmail host i amable 2 send the mail but when i am using yahoo host i get  error msgthe yahoo id & password are right  but still getting the below msg ---------------------------Windows Internet Explorer---------------------------  ' The SMTP server requires a secure connection or the client was not authenticated. Authentication Required. '   ---------------------------OK   ---------------------------

Connect to an existing connection manager from within a custom transformation?

I'm developing a custom data flow transformation and have hit a roadblock.  I need to create an ADO connection to one of the connection managers that's defined in the package already.  I can either hardcode the name of the connection manager, or define it as a custom property....the problem I'm having is accessing it at all.  What I've found is that ComponentMetaData.RuntimeConnectionCollection[0].ConnectionManager only has the connection managers defined by the component itself, not already existing in the package.  How do I create a connection to a connection manager that's defined at the package level at design time? Thanks

Error handling on Connection Manager Expression

I am using a connection manager with an expression to set the connection string. (see my question http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/1ea71f9a-df5c-4c1c-a2fd-9e24632afbd8) I would like to put some error handling just incase things go wrong. Can anybody give me some tips on where to place error handling?Mr Shaw

help configure my connection string

i have created a linq to sql mapping classnow i changed the location of the server but i can't chane the connection string to the new location where can i do this ?HosDataContext db = new HosDataContext();             Sur_Accessory nor = new Sur_Accessory             {                 SurgeryAccessoriesID = Guid.NewGuid(),                 Kind = TextBox4.Text             };HosDataContext db = new HosDataContext();            Sur_Accessory nor = new Sur_Accessory            {                SurgeryAccessoriesID = Guid.NewGuid(),                Kind = TextBox4.Text            };this code brought error after changing the serverError 8 The type or namespace name 'HosDataContext' could not be found (are you missing a using directive or an assembly reference?) E:\WorksAndBackUps\Hospital\4-9-2010\MostafaRadyHospital\MostafaRadyHospital\Admin\Surgery\UCA_SurgeryRoom.ascx.cs 34 37 MostafaRadyHospital

FTP connection manager Editor in ssis

i am using ftp connection manager on my local system.i passed user name as localhost,port number as 21,user name as anonymous,password blank mean nothing.when i test the connection,it give me error as follow,beside i have also provide values for credentials. TITLE: Microsoft Visual Studio ------------------------------ Connection can not be established. Server name, port number, or credentials may be invalid. ------------------------------

The SMTP server requires a secure connection or the client was not authenticated. The server respons

  here everything with images     http://img704.imageshack.us/img704/5520/problem1w.png http://img704.imageshack.us/img704/2116/problem2j.png   http://img530.imageshack.us/img530/5445/problem3.png   http://img829.imageshack.us/img829/6345/problem4.png            

FTP connection manager

Hello, Does anyone know if SSIS supports SSH/SFTP connection? I have an FTP connection manager and I cannot seem to connect. I find it odd that SSIS doesn't ask for the connection. Any help would be appreciated and thank you all in advance.   DaveDave SQL Developer

SSIS Excel Connection Manager Data Type Conversion Issues with SS Agent Job

Hi All! I have an issue I've been trying to fix but can't seem to figure it out. I was hoping a kind person would point me in the right direction. :o) I have an SSIS package that uses an excel connection manager source, and I want to run this package through a job scheduled in the SQL server agent. The data types for the excel file fields are 2 (DT_WSTR) and 5 (DT_R8). When I run the package directly through the SSIS package (VS solution) all of the data fields are properly imported into the database table. But...when I run this package through the SQL server agent job, ONLY the string (DT_WSTR) fields in each row are being imported, all of the float fields are imported as NULL. I set the data types for these float fields as "float" in the SQL server import table (data type). Even though the excel source float fields are indicating a type of DT_R8 in the excel connection manager and I set the data types in the SQL server table to "float", I also used the data conversion component and set the type to "float" as a fail-safe. I guess I should add to that the data access mode in the excel connection manager is using a custom code to select only those columns that I needed and to trim rows that I didn't need. Here's my code that I have in the excel source editor: select f1, f2, f3, f5, f6, f7, f8 from [mdo$] where f2 <> 'Rep Name'

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

get error The SMTP server requires a secure connection or the client was not authenticated. The serv

 Hi,I was able to send mail with no trouble before few days.Then due to some reason, i Formatted pc &  re-installed visual studio & IIS Now when i try to send mail, i get this error.The SMTP server requires a secure connection or the client was not authenticated.In my web.config file i write<mailSettings>      <smtp from="myemail@gmail.com">        <network host="smtp.gmail.com" port="587" userName="myemail" password="xxxx" defaultCredentials="false"/>      </smtp>    </mailSettings>  </system.net>  And on SEND MAIL Button click event I write ( CODE BEHIND)   Dim smtp As New System.Net.Mail.SmtpClient()  Dim smail As New System.Net.Mail.MailMessage smail.To.Add(New System.Net.Mail.MailAddress("contactperson@yahoo.co.in"))        smail.From = New System.Net.Mail.MailAddress("myemail@gmail.com")        smail.Subject = "HELLOO ..HOW R U?"        smail.IsBodyHtml = "true"        smail.Body = "" & txtmail.Text        s

External Content Typ: "Connection manager did not return valid connection."

Hi, I created an external content typ in the sharepoint designer which takes my custom WCF Service as a data source. I sucessfully added all my required operations and created a new list based on the new content typ. At first I had a security issue which I got resolved by editing my BDC configuration in the Central Administration. Now I face a new issue. When I open my external list the BDC Service gives me the following error message: "Connection manager did not return valid connection." Has someone a solution for this kind of message? Thanks, Eric

BIDS Connection Manager Cannot Connect to Remote Oracle Db

Hi All,
I'm not having much luck getting an 'Oracle Provider for OLE DB' remote connection in connection manager to work when creating an SSIS package in BIDS.

I've covered off all the steps in the following link

The local machine is running SQL 2005 Sp2 Enterprise Edition on W2003 Sp2 Standard Edition X64

Using the Oracle 'Net Configuration Assistant' I can connect successfully to the remote service

I'm using ODAC 10g Release 2.

The steps to reproduce the error are as follows

1. in BIDS after creating an SSIS Solution
2. Right click in the  Connection Manager and select new OLE DB Connection
3. Click 'New'
4. Select 'Oracle provider for OLE DB'
5. Under server I enter the service name that I created in the Oracle 'Net Configuration Assistant'
6. Enter the user name and password as I entered in the Oracle 'Net Configuration Assistant'
7. When I click 'Test Connection' I get the following error

Test connection failed because of an error in initializing provider. ORA-12154: TNS could not resolve the connect identifier specified

I've spent a lot of time trying to get this to work and tried othe
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