Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to remove the Windows authentication
 Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Starting Member

1 Posts

Posted - 08/24/2010 :  02:17:43  Show Profile  Reply with Quote
To protect the log in by windows authentication go to the Security and delete the Login Users of BUILTIN\Administrator and BUILTIN\Users.

Then user cannot login by windows authentication.


Go to Top of Page

Posting Yak Master

110 Posts

Posted - 04/28/2011 :  01:49:47  Show Profile  Reply with Quote
Originally posted by tkizer

You can't remove Windows authentication. You can only remove SQL authentication.

And Windows authentication is much more secure than SQL authentication!

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server

HI TARA, hi, i made a project using VISUAL STUDIO 2005 PROFESSIONAL and SQL SERVER 2005. my project is completed and has to deliver now. but i got a problem. the problem is that i worked on SQL SERVER AUTHENTICATION mode i.e. using SA user name and PASSWORD. But instead of this any one can connect to SQL SERVER using Windows authentication mode and can delete or change my databse or tables. so how i solve this problem. can i protect my database?
Go to Top of Page

Almighty SQL Goddess

38200 Posts

Posted - 04/28/2011 :  12:33:53  Show Profile  Visit tkizer's Homepage  Reply with Quote
Abid, you should post your question in a separate thread. To answer your question though:


People can only use Windows authentication if they've been granted that access, so just don't grant that access to them.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server

Subscribe to my blog
Go to Top of Page

Posting Yak Master

115 Posts

Posted - 04/29/2011 :  14:13:09  Show Profile  Visit Jahanzaib's Homepage  Reply with Quote
you can remove windows authentication

1-If any windows user is added then remove it from the security

2-Built-in Administrator ,you can restrict them or remove sysadmin role or remove rights then they cant access on the SQL Server


Syed Jahanzaib Bin Hassan

My Blog
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

1834 Posts

Posted - 05/06/2011 :  19:25:43  Show Profile  Reply with Quote
At the risk of overlooking the glaringly obvious...

Why do you care about the tpye of Login used? Windows Login and SQL Login are just two ways to Authenticate who the person is; neither one implies any special rights. If you only want SQL Logins to have access to the goodies, you handle that by defining the rights assigned to the SQL Logins and not assigning rights to any Windows Login.

Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986)
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000