How to change the SQL Server Authentication Mode in SQL Server 2008?

In Server Properties, click Security under Select a Page on the left side panel. Then you will be able to see the currently used SQL Server Authentication Mode. Now you can change Server authentication mode.

  1. If you would like to change the SQL Server authentication mode, then select the authentication mode under Server authentication and click OK to change the authentication mode and restart SQL Server Database Engine services to reflect the changes. 
  2. You can also generate the TSQL script to change the authentication mode by selecting any of the options under Script drop down as highlighted in the snippet below in Server Properties window. 



Comments

Preeti to Unicode Converter

Popular posts from this blog

Nepali Unicode with Keyboard Layout (Traditional and Romanized)

Units of Land Area Calculation in Nepal

Havij 1.15 Advanced SQL Injection Tool

Learn Customer Information Control System (CICS)

Services of NTC

How to save the life of battery in cell (mobile) phone ?

Easiest video cutting and joining software: Free Video Cutter Joiner version 10.6

Windows Movie Maker 2016 Free Download

Ransomware Cyber Attack: One of the biggest Cyber attack in this year

Top 10 most popular search engines (researched on October 2013)