SQL SERVER R2 set mode

[kornkimhour]

Hi I want to set Sql server R2 with sql server mode,but I can not find it in Sql server R2 mode.it have only 2 mode window Authencation or Mix mode.do you have an idea about this? thank in advanced

[Mycroft Holmes]

This article [^]seems to imply that sql only authentication is not recommend. MS want you to use AD authentication!

Never underestimate the power of human stupidity RAH

[Sandeep Mewara]

There are two possible modes: Windows Authentication mode and mixed mode in SQLServer 2008 R2. Here, have a look at details here: MSDN: Choosing an Authentication Mode[^] MSDN: How to: Change Server Authentication Mode[^]

Sandeep Mewara Microsoft ASP.NET MVP 2012 & 2013 [My Blog]: Sandeep Mewara's Tech Journal! [My Latest Article]: HTML5 Quick Start Web Application