Sql-authentication and Query Analyser/EM

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thor W Hammer - 14 Oct 2005 11:42 GMT

If connecting to a database with Query Analyser or Enterprise Manager using
Sql-authentication, is the login information sent over the network in clear
text?

Regards,
TWH

Reply to this Message

Jasper Smith - 14 Oct 2005 20:01 GMT

Not exactly, it is obsfucated rather than encrypted and so can be determined
reasonably easily from a network trace. SQL2005 improves on this and all
login communication is encrypted.

Signature

HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

> If connecting to a database with Query Analyser or Enterprise Manager
> using Sql-authentication, is the login information sent over the network
> in clear text?
>
> Regards,
> TWH

Reply to this Message