Home Forums SQL Server 2005 Administering Password encryption-decryption logic in SQL Server 2005 RE: Password encryption-decryption logic in SQL Server 2005

  • from what i understand, what you are trying to do isnt supported by any OLE/ODBC provider I know of. Usually you encrypt a password when saved in a file (like web.config or whatever), read it in your application, decrypt it, build connection string, connect to server.

    If you are concerned about plain text, etc, you need to encrypt your connection, or use integrated authentication instead (as integrated stores no password, its windows auth)

    secure connection:

    http://technet.microsoft.com/en-us/library/ms189067.aspx