Difference between Windows Authentication and SQL Server Authentication

Question

When connecting to live server in the Authentication box do I use Windows Authentication or Server Authentication

dharmendr · Accepted Answer

Hi RichardSaYou need to select SQL Server AuthenticationConnecting Through Windows AuthenticationWhen a user connects through a Windows user account SQL Server validates the account name and password using the Windows principal token in the operating system This means that the user identity is confirmed by Windows SQL Server does not ask for the password and does not perform the identity validation Windows Authentication is the default authentication mode and is much more secure than SQL Server Authentication Windows Authentication uses Kerberos security protocol provides password policy enforcement with regard to complexity validation for strong passwords provides support for account lockout and supports password expiration A connection made using Windows Authentication is sometimes called a trusted connection because SQL Server trusts the credentials provided by WindowsConnecting Through SQL Server AuthenticationWhen using SQL Server Authentication logins are created

dharmendr · Answer

Since you are connecting to the remote server not your windowsSQL server is installed in the server

Difference between Windows Authentication and SQL Server Authentication

Company

Explore

Follow us

Contact Us