Is the SQL Enterprise Manager tool secure?

Or more exactly, is the authentication process when
registering a server encrypted in some fashion while
travelling over the network?
TIA,
Eric"Eric" <anonymous@.discussions.microsoft.com> wrote in message
news:13f6501c3f7e3$b11b5060$a401280a@.phx
.gbl...
> Or more exactly, is the authentication process when
> registering a server encrypted in some fashion while
> travelling over the network?
>
If you register as 'Use Windows Authentication' confidential user/password
information is not transmitted. While I have not traced it, I suspect that
SQL Server Authentication would transmit the user name and password in clear
text.
Steve|||The password is "obscured" for SQL logins but hardly encrypted which is why
Windows Authentication is preferred.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:%23VmoJM$9DHA.3900@.TK2MSFTNGP10.phx.gbl...
> "Eric" <anonymous@.discussions.microsoft.com> wrote in message
> news:13f6501c3f7e3$b11b5060$a401280a@.phx
.gbl...
> If you register as 'Use Windows Authentication' confidential user/password
> information is not transmitted. While I have not traced it, I suspect that
> SQL Server Authentication would transmit the user name and password in
clear
> text.
> Steve
>|||You can encrypt your traffic with SSL.
314636 FIX: Cannot Use Non-Administrator Account to Start SQL Server and
Force... http://support.microsoft.com/?id=314636
276553 HOW TO: Enable SSL Encryption for SQL Server 2000 with Certificate
Server http://support.microsoft.com/?id=276553
322144 SECDoClientHandShake Cannot Connect to SQL Server
http://support.microsoft.com/?id=322144
257591 Description of the Secure Sockets Layer (SSL) Handshake
http://support.microsoft.com/?id=257591
316898 HOW TO: Enable SSL Encryption for SQL Server 2000 with Microsoft...
http://support.microsoft.com/?id=316898
324777 WebCast: Microsoft SQL Server 2000: How to Configure SSL Encryption
http://support.microsoft.com/?id=324777
318605 INF: How SQL Server Uses a Certificate When the Force Protocol
http://support.microsoft.com/?id=318605
325757 INF: Using SQL Server 2000 with FIPS 140-1 Ciphers
http://support.microsoft.com/?id=325757
302409 FIX: Unable to Connect to SQL Server 2000 When Certificate
Authority... http://support.microsoft.com/?id=302409
311111 FIX: RPC Clients Unable to Login to SQL Server with Windows...
http://support.microsoft.com/?id=311111
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.