March 7, 2005 at 12:24 pm
How can I displable the Window authentication login and use only sa created login to the SQL Server?
What is the effect if I disble Window Authentication login?
March 7, 2005 at 12:27 pm
Well, since SQL Server runs in either Windows Authentication Mode or Mixed Mode (SQL and NT), I guess your best bet is to:
-Remove all NT based server logins
-Remove 'Builtin\Administrators' Group
I haven't tested it, but this should get you started on locking out all NT users and domain admins.
March 8, 2005 at 10:11 am
The advice given is the only way to get to SQL Server logins only. If there is a Windows user account/group granted login rights to SQL Server, it'll be able to connect.
Be careful on the removal of BUILTIN\Administrators. There are a few steps you'll have to perform before going down this road. A couple of articles on this site detail what to do.
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply