HDTutorial
EN

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

How to reset system administrator (sa) password in Microsoft SQL Server

748 views July 8, 2020 3:33

Watch on YouTube
ChannelAM7Tech

Description from the creator

Before everythting make sure of three options to be selected inside Windows Authentication mode specifically in Server name and Logins (sa) properties:-
1- Go to Server Name and right click on it, choose properties then Security...in "Server authentication" select SQL Server and Windows Authentication mode then press ok.
2- Go to Security then Logins and right click on sa then choose properties and left click on Status, in "Permission to connect to database engine" select Grant. In "Login" select Enabled and press ok.
-------
Forgot your sa password? don't worry just follow the main steps now :-
1- Open Windows Authentication and not SQL Server Authentication.
2- Go to Security and then Logins.
3- Go to sa then right click on it and choose Properties then General.
4- Put your new password twice, in Password field and Confirm password field then press ok.
5- Close server connection and open it again, choose SQL Server Authentication and put for Login sa and for Password your new password.

I hope you enjoy watching the video :)

About this tutorial

AM7Tech published this 3:33 video tutorial on July 8, 2020. It has been watched 748 times on YouTube.

Channel
AM7Tech
Duration
3:33
Published
July 8, 2020
Views
748
Likes
8

Share

This tutorial in other languages