method of encrypting the pass of IP, PASS, USER to the SQL ?

Is there a method of encrypting the passing of IP, PASS, USER to the SQL
server without using VPN ?
Thanks
ScottAre you talking about encrypting it on the wire? Or storing it in a
databases?
--
----
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"scott" <nospamscott@.yahoo.com> wrote in message
news:uSK0EDblEHA.2948@.TK2MSFTNGP11.phx.gbl...
> Is there a method of encrypting the passing of IP, PASS, USER to the SQL
> server without using VPN ?
> Thanks
> Scott
>|||"scott" <nospamscott@.yahoo.com> wrote in message
news:uSK0EDblEHA.2948@.TK2MSFTNGP11.phx.gbl...
> Is there a method of encrypting the passing of IP, PASS, USER to the SQL
> server without using VPN ?
In my experience and based on a few minute's sniffing, the login id and
client hostname always appear in clear text whatever the connection method.
For DB-Library SQL Server authenticated logins, the password is always clear
text.
For ADO SQL Server authenticated logins, the password is encrypted.
For Windows authentication (aka trusted authentication), passwords are not
passed with the TDS login packet: they are already passed encrypted at an
earlier stage.
Kind Regards, Howard