how userid and password exposed in network in sql authentication

76 Views Asked by At

How is the userid and password exposed on the network in SQL authentication and why doesn't this happen in Windows authentication?

1

There are 1 best solutions below

0
On

In Windows authentication, SQL verifies the security token created for the user when they logged into their Windows machine, and never actually requires the password. If you connect to a remote SQL server with SQL Authentication, you have to submit a password, and you are then depemdant on the network communication to be secure.