Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

migrated from stackoverflow.com May 24 '10 at 22:16

This question came from our site for professional and enthusiast programmers.

    
you're about management studio, or about connection from app? –  loviji May 24 '10 at 3:07
    
oh..i dnt know we can do both management n from app..can u tell me both?thx b4 –  leonita May 24 '10 at 3:13
    
Hi. Your acceptance rate for questions you have asked is very low. This may prevent you from receiving more answers for this and future questions. You should get into the habit of accepting answers if a suitable one was given. It really helps the community at large. –  Garett May 24 '10 at 3:23
    
oh..i dnt knw about it....so answering , effected hw much we can ask n receiving someone answer..ic –  leonita May 24 '10 at 4: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: meta.stackexchange.com/questions/5234/… –  Garett May 24 '10 at 5:24

3 Answers 3

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;
share|improve this answer

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.

share|improve this answer

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.