Playback starts YouTube’s embedded player (privacy-enhanced mode).
How to connect to SQL Server when there is no System Administrator(sysadmin) Login.
Channelhectorsmith786Description 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.
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.
- Channel
- hectorsmith786
- Category
- Education
- Duration
- 9:11
- Published
- November 10, 2013
- Views
- 143,132
- Likes
- 214
Tags
Share
This tutorial in other languages
- FRComment se connecter à SQL Server quand il n'y a pas de login administrateur système (sysadmin).
- ESCómo conectarse a SQL Server cuando no hay administrador del sistema (administrador del sistema) Login.
- PTComo se conectar ao SQL Server quando não há Acesso de administrador do sistema (sysadmin).
- ITCome connettersi a SQL Server quando non c'è amministratore di sistema (sysadmin) Login.
- DEWie man SQL Server verbinden, wenn kein Systemadministrator (Sysadmin) Anmeldung ist.
- NLHoe te verbinden met SQL Server wanneer er geen System Administrator (sysadmin) Log.
- RUКак подключиться к SQL Server, когда нет системного администратора (сисадмина) Логин.
- PLJak połączyć się z SQL Server, gdy nie ma administrator systemu (administrator) zalogować.
- JA何のシステム管理者(システム管理者)ログインがない場合にどのようにSQL Serverに接続します。
- ARكيفية الاتصال SQL Server عند عدم وجود مسؤول النظام (مسؤول النظام) دخول.
- HIकैसे एसक्यूएल सर्वर से कनेक्ट करने के कोई सिस्टम प्रशासक (सिस्टम प्रशासक) लॉगिन।
- IDBagaimana menghubungkan ke SQL Server ketika tidak ada System Administrator (sysadmin) Login.