Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GaneshRamanan
Starting Member
40 Posts |
 Posted - 2011-01-25 : 05:40:39
|
| Hi,I need only SQL Authentication mode for login into server, how can I Restrict the Windows Authentication Mode.Thanks,Ganesh Ramanan |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-01-25 : 05:43:44
|
| Can't remove it.Just don't add any windows logins - I take it you're not trying to stop admins from accessing the server? If so you need to restrict builtin administrators - think that's what it is/was called.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
GaneshRamanan
Starting Member
40 Posts |
Posted - 2011-01-25 : 06:17:49
|
| Eventhough I have removed the BUILTIN\Administrators Logins, they can Access the Server in WindowsAuthentication Mode. How I can restrict the Windows User.Thanks in Advance,Ganesh Ramanan |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-01-25 : 06:37:49
|
| Don't grant them access. If a windows user is not granted access to SQL via either the user or a group, they will not be able to connect.What windows authentication logins do you have?--Gail ShawSQL Server MVP |
|
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-01-25 : 06:46:31
|
| Disable and Deny all the logins who you don't want to access the SQL sever via following commands!DENY CONNECT SQL TO [WindowsLoginName]ALTER LOGIN [WindowsLoginName] DISABLECheers!MIK |
|
|
|
|
|
|
How to Protect Authentication