HDTutorial
EN
How to recover SA password on Microsoft SQL Server 2008 R2|| Forgot Password For Sql Server Recovery

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

How to recover SA password on Microsoft SQL Server 2008 R2|| Forgot Password For Sql Server Recovery

165,128 views November 8, 2014 5:35

Watch on YouTube
ChannelSkytuts

Description from the creator

When you are using MS SQL Server in mixed mode, it is very important that you know your SA password.

There can be different reasons you lost the password

Person who installed the SQL Server knows the password but has left the building.
You did not write down the password in your password file
Password file is lost

Command to use in cmd prompt:

CREATE LOGIN recovery WITH PASSWORD = 'TopSecret 1′

sp_addsrvrolemember 'recovery', 'sysadmin'

copy paste and press enter ........

Thank you for watching

About this tutorial

Skytuts published this 5:35 video tutorial on November 8, 2014. It has been watched 165,128 times on YouTube.

Channel
Skytuts
Category
Education
Duration
5:35
Published
November 8, 2014
Views
165,128
Likes
159

Tags

Share

This tutorial in other languages