how to disable the windows authentication mode in sql server?
user must have a password to login to the server
is it possible to do that?
Printable View
how to disable the windows authentication mode in sql server?
user must have a password to login to the server
is it possible to do that?
When I had to do that I had to re-install SQL server2000.
Check out this site :
http://www.codeproject.com/database/ConfigureMSDE.asp
If your server configuration is for Mixed Mode, then you should be able to have both Windows Authentication and SQL Server Authentication. If that's the case, then you can revoke access to the Windows logins and create the SQL Server logins that are to be used for connecting.
is it possible to make it even user logged in to windows, but must have a password to login to sql server?