Category Archives: SQL Authentication modes

Changing Authentication mode in SQL Server 2005

SQL Server authentication mode is usually configured during SQL Server installation. By default, Windows Authentication mode is configured. Ok, What if we want to override the mode configured during installation. As you may know, SQL Server 2000/2005 supports three authentication modes: 1) Windows Authentication Mode2) SQL Authentication Mode3) Mixed Mode Authentication (SQL/Windows) Here’re following steps… Read More »