Launch Microsoft SQL Server Management Studio and connect to the SQL Server instance.
In the Object Explorer, drill down to Security and Logins.
Right click to the user which you want to drop and select Delete.
Click OK.
Click OK again to proceed with the deletion.
Alternatively, you can use the following query,
DROP LOGIN USER-NAME ;
