HDTutorial
EN

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to connect to SQL Server when there is no System Administrator(sysadmin) Login.

143,132 views November 10, 2013 9:11

Watch on YouTube
Channelhectorsmith786

Description from the creator

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.

About this tutorial

hectorsmith786 published this 9:11 video tutorial on November 10, 2013. It has been watched 143,132 times on YouTube.

Category
Education
Duration
9:11
Published
November 10, 2013
Views
143,132
Likes
214

Tags

Share

This tutorial in other languages