Change server authentication to a Mixed mode

Problem

Many applications require the use of SA and other SQL logins to work properly. To achieve it, we need to make sure that SQL Server is using Mixed Mode (i.e., both Windows Authentication and SQL Server Authentication are allowed)

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_change_server_authentication.sql

Example