How to connect to SQL Server when there is no System Administrator(sysadmin) Login.
Hello everyone in this tutorial i will show you how to assign a sysadmin role to login when there is no system administrator available. One of my friend removed the sysadmin roles from a single sysadmin role login on his server & also the mixed mode was disabled, now he got stucked in a critical situation. So first i enabled the sql server authentication mode by first creating a dedicated connection sql server & then set password for the 'SA' account which was disabled. After enabling the sql server authentication mode & after setting the password for 'SA' login, i successfully logged into sql server & then reassign the sysadmin role to the previous login. I hope you will enjoy this tutorial & i will receive some interesting comments...
Thanks for watching.