How to secure SqlConnection's password without Integrated Security? RRS feed

  • Question

  • C# / .Net 2.0 / SS2000 / VS2005


    Hi all,


    I have a console application that imports data into a SQL2000 database. I have the following connection:


    SqlConnection cnStockLending = new SqlConnection(connectionString);


    I was wondering how I could make my code more secure, (protecting my password and id)

    without using Integrated Security?




    Thank you for your suggestions,
    Thursday, August 2, 2007 11:34 AM


  • You could encrypt the information, wherever you should decide to store it, and then decrypt it in your application before supplying it in your connection string.


    Thursday, August 2, 2007 11:58 AM

All replies