Fix Error 15190: There are still remote logins for the server ‘DBSERVER’.

I got this error 15190 while renaming SQL Server Instance name. I was not able to drop the existing SQL Server instance name using sp_dropserver stored procedure and was getting error 15190. Full description of this error is given below....