How to reset password of sql server 2008 r2?
Answers
Answered by
1
✔Go to the SSMS installation page in a browser.
✔Click the Download SQL Server Management Studio 17.6 link.
✔Double-click the downloaded SSMS setup file.
✔Follow the on-screen prompts to install SSMS.
✔Open SSMS. Type sql server management studio into Start, then click Microsoft SQL Server Management Studio 17 at the top of the Start window.
✔Select the correct authentication.Click the "Authentication" drop-down box, then click Windows Authentication in the menu.
✔Click Connect. It's at the bottom of the window. If Windows Authentication is allowed for your account, doing so will log you into your server's dashboard.
✔Expand your server's folder. If your server's folder in the upper-left side of the window doesn't have several options below it, click the ＋ icon to the left of it to expand it.
✔Expand the "Security" folder. It's below the server's name.
✔Double-click sa. It's in the "Logins" group of options. Doing so opens your System Administrator properties window.
✔Click OK. It's at the bottom of the window. Doing so will change your password and close the properties window.
✔Click the Download SQL Server Management Studio 17.6 link.
✔Double-click the downloaded SSMS setup file.
✔Follow the on-screen prompts to install SSMS.
✔Open SSMS. Type sql server management studio into Start, then click Microsoft SQL Server Management Studio 17 at the top of the Start window.
✔Select the correct authentication.Click the "Authentication" drop-down box, then click Windows Authentication in the menu.
✔Click Connect. It's at the bottom of the window. If Windows Authentication is allowed for your account, doing so will log you into your server's dashboard.
✔Expand your server's folder. If your server's folder in the upper-left side of the window doesn't have several options below it, click the ＋ icon to the left of it to expand it.
✔Expand the "Security" folder. It's below the server's name.
✔Double-click sa. It's in the "Logins" group of options. Doing so opens your System Administrator properties window.
✔Click OK. It's at the bottom of the window. Doing so will change your password and close the properties window.
Similar questions