Sunday, February 19, 2012

How do i disable Windows Authentication mode to log into the DB?

How do i disable Windows Authentication mode and just have SQL Server Authentication mode?

is it even possible?


Yes possible. Right click on the Server -> Properties -> Security.|||

theres only two choices:

Windows Authentication mode OR BOTH Windows and SQL Authentication.

I just want SQL Authentication.

|||You cannot disable windows authentication entirely. Also, enabling windows authentication does not mean every windows user can login. The windows login should be added to the logins module to access the db.

No comments:

Post a Comment