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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-21 : 07:54:50
|
| Sanjeev writes "All:There is a server with SQL 2K standard installation.Objective : I want that any kind of acess to the database, should be thru SQL Authentication only.I totally want to avoid the NT Authentication in any case of DB access.Even when this server is tried to be registered/accessed by installing a SQL client on some machine and registering it.This is because the Server console is shared with other people via RA/RDC/VNC. etc.I 'll appreciate a very quick response, as we are about to go LIVEThanks in advanceSanjeev" |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2003-10-21 : 08:40:18
|
| You cant stop NT Authentication. You can either have NT Authentication or NT Authentication plus SQL Server Authentication (provided for backward compatability).Although you can't stop NT Authentication, you can have no NT Users defined. You may need to think about removing all NT user from the server logins, including Builtin\Administrators. And then add only SQL Users to your server.Raymond |
 |
|
|
|
|
|
SQL Authentication