SQL Logins are always encrypted on the wire as of SQL Server 2005. From
http://msdn.microsoft.com/en-us/library/ms131691.aspx
Cheers,
Bob Beauchemin
SQLskills
"alw" wrote in message
> Are SQL Server 2008 Logins (not integrated logins) passwords automatically
> encrypted on the wire (I know they are on the hard drive) by default, or
> is
> there a certain combinations of settings that must be used to have the
> passwords encrypted on the wire.
>
> If so, what settings.
>
> Thanks. Ann