Setting the Server Authentication property to Windows authentication mode

Note: Changing this setting can impact all the other products on the database server that use the SQL authentication. Ensure that the settings do not impact the other products.

Windows authentication is used for validating the attempted connections. Windows provide a more robust authentication mechanism than the SQL Server authentication.

To set the Server Authentication property to Windows Authentication mode:

  1. Open the SQL Server Management Studio.
  2. Open the Object Explorer tab and connect to the target database instance.
  3. Right click the instance name and select Properties.
  4. Select the Security page from the left menu.
  5. Set the Server authentication setting to Windows Authentication mode.