By design a table shouldn’t contain duplicate rows. However sometimes under peculiar cases a table may end up having duplicate...
SQL Server supports two authentication Modes
1) Windows Authentication
In case of Windows Authentication, the KERBEROS token assigned during the logon process would be sent to SQL Server when requesting resources. In this case, such kind of accounts must belong to the same domain as the hosting SQL Server. In the Active Directory domain environment, an additional level of protection is provided by Kerberos protocol, which governs the behavior of the Windows authentication mechanism. Microsoft recommends Windows Authentication.
2) Mixed Mode Authentication (Windows Authentication & SQL Server Authentication)
Mixed authentication mode allows the use of Windows credentials but supplements them with local SQL Server user accounts that the administrator may create and maintain within SQL Server.
SQL Server Authentication:
When should we use SQL Server Authentication?
How to change the authentication mode to Mixed?
The default authentication mode enabled in SQL Server is “Windows”. It is pretty easy to enable Mixed Mode.
1) Open SQL Server management studio and connect to the SQL Server using “Windows Authentication”.
2) Right click on the server and select “Properties”
3) Select “Security” left menu item on the “Server Properties” window.
4) Select “SQL Server and Windows Authenitcation Mode” radio button
5) Click on “OK”
6) Below confirmation pop-up shows up. Click “OK” again
7) Restart your management studio .