February 26, 2011 at 1:05 am
How to Disable Windows Authentication in sql server 2008?
February 26, 2011 at 1:57 am
It can't be disabled. You could remove all windows logins, that would do just about the same. Just make sure you have another sysadmin login.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 2, 2011 at 2:28 pm
You may not want to remove all of them, please see this post: http://www.sqlservercentral.com/Forums/FindPost541758.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 3, 2011 at 3:13 am
First you have to drop the built-in/administrators using
drop login [bultin/administrators] and then here after u shouldn't create an any logins related to windows account..so this is the one way for restrict the users for entering in to the server through windows account.
There is no option for disable the windows authentication mode,as of now we have only either only sql server authentication mode or mixed mode(windows and sql server).
March 3, 2011 at 8:13 am
Why would you want to remove windows authentication? Our goal is to never use SQL authentication, and we only do so when required by a vendor application.
March 3, 2011 at 12:09 pm
When you are dealing with managing a shared DB server for websites it is a lot easier to manage SQL credentials then an AD structure
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply