Reply To: How to change authentication mode in SQL Server 2008? Lincoln Burrows ~ Modified: 29-Sep-2015 ~ ~ 1 Minute Reading Home › Forums › How to change authentication mode in SQL Server 2008? › Reply To: How to change authentication mode in SQL Server 2008? September 29, 2015 at 7:15 am #763 Score: 0 Lincoln BurrowsModerator Karma: 16 pts Open the registry and search for key LoginMode under: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Update the LoginMode value as 2. Go