1 Reply Latest reply: Mar 26, 2014 3:38 AM by Bumin Koesesoy RSS

    encryption/hashing of clear text password for SQL Server?

      I need help with encryption/hashing of clear text password for SQL Server, without manually creating through connect string through the "Data Link Properties" dialog.

       

      e.g. replace

      OLEDB CONNECT TO [Provider=SQLOLEDB;User ID=sa;Initial Catalog=Demo;Data Source=CTX39] (Password is pass);

      with

      OLEDB CONNECT TO [Provider=SQLOLEDB;User ID=sa;Initial Catalog=Demo;Data Source=CTX39] (XPassword is AIceIYFMTbcOL);

       

      How can I get "AIceIYFMTbcOL" for "pass" without going through the creation of connection string in QV & then copying it to configuration file process; for each User ID/Initial Catalog/Data Source/Password combination.

       

      Thanks,

      Prashant