How do I disable Windows authentication on a SQL Server instance?

Question

you're about management studio, or about connection from app? — loviji, May 24 '10 at 03:07
oh..i dnt know we can do both management n from app..can u tell me both?thx b4 — , May 24 '10 at 03:13
oh..i dnt knw about it....so answering , effected hw much we can ask n receiving someone answer..ic — , May 24 '10 at 04:22
Since SO has a reputation system based on points, it is the right thing to do in order to motivate folks to answer other questions. Please see the following: http://meta.stackexchange.com/questions/5234/accepting-answers-what-is-it-all-about — Garett, May 24 '10 at 05:24

score 3 · Answer 1 · answered May 24 '10 at 03:09

if you are about management Studio, please read this article

You can't remove Windows authentication. You can only remove SQL authentication.If you don't want to use windows authentication, don't create sql login for windows account.

if you are about connection to sql server from applications modify connection string in config files like this:

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

score 0 · Answer 2 · answered Jun 03 '10 at 17:53

0

You could create each Windows group/user (that can connect to the box and might access SQL Server) in SQL Server security logins and deny permission and disable the login.

answered Jun 03 '10 at 17:53

score 0 · Answer 3 · answered Jun 03 '10 at 17:55

You can't put SQL Server in to SQL logins only mode, but you achieve the same thing by removing all Windows accounts & groups from having access. If SQL Server logins are all that are setup and there;s not guest permissions configured then you're done.

How do I disable Windows authentication on a SQL Server instance?

3 Answers3