Mirror

SQL Server Security Setting (Views: 101)


Problem/Question/Abstract:

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.

<< Back to main page