.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

Connection manager doesn't save password

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


My connection managers don't save the passwords. The definitions are read from a configuration file, but when I view the properties, I see a blank field, and then if I fill the password, close the dialog and open it again, the field is blank again, although I checked the "Save my passwords" checkbox.

What's going on?

View Complete Post

More Related Resource Links

SSIS -2008 R2 - ODBC Connection error - Password does not save


Please know that I am new to SSIS 2008 and XML. Have a package I am trying to deploy. Am on a HV 64 Bit environment SQL Server 2K8 R2. Have an ODBC connection to our HBOC system as a data source. As always package runs in test environment and not in prod.  I need a bit of insight into the what and why's of the configuation file and how to change out the XML. 

Main issue is the password not saving and how to handle the ODBC side of things. I appreciate any help in this matter as I have searched with no real understanding of XML and best practices of creating the Congif file.


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

Working with CodePlex. How to save password for project?


I want to make public one small project on CodePlex. Everybody knows that you can work with CodePlex like with TFS client and with SVN client as well. But really I can't work with it from SVN client. When I tried to add some binary file (it was dll) I got the error "Server sent unexpected return value (200 OK) in response to PUT request for .". How to solve this problem I don't know, I found thread at CodePlex's discussions Can't commit binary files using TortoiseSVN, but last message was at past year. Ok, I'm working with TFS at work, so for me it will be not a problem connect to CodePlex with TFS. But there are some distressing case, Visual Studio always ask credentials at every new connection to project. And I didn't find a checkbox "Save credentials". But I found the method. Read more...

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

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

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. ------------------------------

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'

Connection string with password or impersonation

Which is the best solution for a program which runs as networkservice (or defined user) and needs to be connected to a database as a specific user: DbConnection ConnectionString with username and password                                          or Impersonate Windows Identity just before running the query Keep in mind security is important in my case.  

list view connection filter doesn't work

  I have  a custom display form for documents library with two connected List View WebPart. I am trying to filter documents at the second list view with the value from the first one. Both list views contain data from the same documents library. I have configured the connection, but second list doesn’t display any item, and it doesn’t matter which field I use for filtering. Also  for another document s library’s custom  display form  it work perfect.But there second list view contain data from another documents library. Not the same as at first   case. Any ideas with my issue?

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

Unable to obtain password in the connection string


I am reading a connection string for SQL Authenicated user from the SSIS Package Configuration file which looks like

Data Source="ServerName";Initial Catalog="DB";User Id="UID";pwd="PWD";Integrated Security= false;Persist Security Info=True;


I am accessing the above connection string in the script task. But the conection string comes without the password and it says login failed for the user. I am unable to get the password. 


Any help is much appreciated. Thanks in advance.



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

Data conversion failed --flat file connection manager


Hello All,

Can any one help me in this .

[Flat File Source [16]] Error: Data conversion failed. The data conversion for column "acct" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".

[Flat File Source [16]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "output column "acct" (373)" failed because error code 0xC0209084 occurred, and the error row disposition on "output column "acct" (373)" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.

[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADCANCELLED.  Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.  There may be error messages posted before this with more information on why the thread was cancelled.


can any one help me in this error :


[Lookup [465]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "component "Lookup" (465)" failed because error code 0xC020901E occurred, and the error row disposit

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