How can I encrypt SQL Server Authentication credentials?
Posted on 2007-12-06
We have a SQL Server 2005 server which is not part of a domain. We want to use SQL Server Authentication in order to connect to this server, but want the login credentials to be encrypted when the connection attempts to the servers are made so that no one can sniff out the credentials. Using Windows Authentication is not an option at all.
This is a highly sensitive server and we want to ensure that no one will be able to sniff out the login credentials as a user attempts to connect to the SQL Server, this is why we need to be able to encrypt the credentials as the connection attempt is made.