Keep it Simple and Smart
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
» Read moreDuring the installation of SQL Server if you choose the windows authentication mode and sa login is disabled. With the help of following steps you can change the authentication mode from windows to SQL Server authentication mode. Change the Authentication Mode In SQL Server Management Studio Object Explorer, right-click the
» Read moreDuring 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
» Read moreWe 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
» Read moreVarinder Sandhu is using WP-Gravatar