Author: Majid Vafaei Jahan
How I can Set SQL Server Security in SQL Server Authentication without windows
Authentication.
Answer:
You must install new sql server and set authentication in mix mode or SQL Server
and Windows authentication.
In Sql Manager, Add New Group and add New SQL Server and set connection type to SQL
Server Authentication with checking check box (Always Prompt).
In Security/Login Section you should set BUILTIN/Adminstrator to Access Deny.
Every Users with windows authentication should had appropriate access with Deny
Access.
Every Users with Funcional access such as creating, droping,... tables should had
SQL Server Authentication with appropriate Password.
Sa should SQL Authentication wih appropriate password.