SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

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

khaledcs
Starting Member

Bangladesh
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.

Thanks,
khaled

khaled
Go to Top of Page

Abid
Yak Posting Veteran

Pakistan
77 Posts
Posted - 04/28/2011 :  01:49:47  Show Profile  Reply with Quote
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
http://weblogs.sqlteam.com/tarad/

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

tkizer
Almighty SQL Goddess

USA
35007 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:

DON'T USE SA IN YOUR APPLICATION!

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
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Jahanzaib
Posting Yak Master

Pakistan
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



Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1429 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
 New Topic  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.09 seconds. Powered By: Snitz Forums 2000