TRAIN TRACK"

Allow both Windows and SQL authentication in SQL Server

Q: How do I set SQL Server to allow both Windows and SQL authentication?

A: Follow these steps:

  1. Open SQL Management Studio.
  2. In the tree at the left, Right-Click on the server name.
  3. Select Properties in the pop-up menu.
  4. Select Security.
  5. Check the box to allow both SQL and Windows authentication.

Tags: SQL authentication, Windows authentication, installation.