I am confused about how this works:
I was reading the SQL Server documentation on authentication here:
Windows Authentication is always available and cannot be disabled
This makes me think that ALL connections to SQL server NEED windows authentication (as it cannot be disabled), but it goes on to talk about the advantages of having only SQL Server authentication, for example:
Advantages of SQL Server Authentication
- Allows SQL Server to support environments with mixed operating systems, where all users are not authenticated by a Windows domain.
So, can you connect to SQL server without Windows Authentication or not?