Tag: Authentication

SQL Server – Understanding of SQL Server Role and Database Role

SQL, SQL-Advanced, SQL-General, SQL-Server 2012, SQL-Tips and Tricks

SQL Server supports the two authentication mode as Windows authentication mode and Mixed authentication mode. Once the user is authenticated, SQL server will allow access to the user based on the permission that user has. All the user permissions are based on Server Role and Database Role. So let try to user understand the meaning of each server role and database role. Server Role: Role Name Permission user can have bulkadmin Can run the BULK INSERT statement. dbcreator Can create,

» Read more
, , ,

SQL Server – Authentication Mode – Windows Mode and Mixed Mode

SQL, SQL-Advanced, SQL-Tips and Tricks, Varinder Sandhu

During the installation of SQL Server you can choose the authentication mode for Database Instance. SQL Server support the two authentication mode as Windows authentication mode: Windows Authentication mode enables Windows Authentication and disables SQL Server Authentication.  Even if you choose Windows Authentication mode during SQL Server installation “sa” user is created but disable for SQL Server Authentication. But later we you can use “sa” user by enabling for SQL Server Authentication .Any window user can configure as system administrator

» Read more
, , , ,

Authentication Vs Authorization – Security Concepts

.Net Framework, Varinder Sandhu

We all know about the security concepts, Authentication and Authorization. However, it is really important to know the difference between Authentication and Authorization.  Lot of detailed stuff is available over the internet but here sharing with you the brief information about the difference between Authentication and Authorization, so that we can easily understand about these concepts. Simply, Authentication is checking the user‘s identity, and Authorization is verifying a user’s right to access resources. Authentication The process of identifying the user, this

» Read more
, ,