Computers OverClocked Forums Computers OverClocked
"Not just another computer help website."

FAQ Search Upgrade Register
Favorite Threads Private Messaging Login

Over Clocking Guide
Over Clocking Help
Computer Building Help
Virus/Security Alerts
Broadband Tweaks
Computing Guides
Featured Hot Deals

Top 25 reasons to register!

Advertise your link here for $19.99/month!

 Computers OverClocked Welcomes You!
 Date/Time is Mon Nov 19, 2018 11:45 am
 Computer Photo Gallery
Computing News Headlines:
New HTC Android Phones Tweaked to Evade Apple Patents
Ivy Bridge Temperatures – It’s Gettin’ Hot in Here
Adobe CS6 on sale today, Creative Cloud coming May 11th

3 Methods to Change SQL Server Password
Post new topic Reply to topic Computers OverClocked Forums - Hardware/Software User Reviews All times are GMT - 5 Hours - EDT
Author Message

User is offline 
Send private message
Joined: May 07 2012
Posts: 51

PostPost subject: 3 Methods to Change SQL Server Password
Posted: Tue Jul 17, 2012 3:55 am
Reply with quote

Most security experts refer to enhancing SQL Server password security by changing password. To change SQL password[/url is easy and one can make it through the following methods:

[b]Method 1: Changing SQL Server user password by using MSSQL Server Management Studio Express.

1. Login to your Server using MSSQL Server Management Studio Express. Make sure to specify the correct SQL server for your database.
2. Expand the tree menu on the right by clicking on the "+" next to Security followed by clicking on the "+" next to Logins. Your users for the database in question should be listed.
3. Right click on the user you wish to change the password for and choose the Properties option at the very bottom of the menu.
4. Under the general section of the window you will see the option to type in and confirm a new password. Once the new password has been typed in, then click the "Ok" button in the lower right to finish.

Method 2: Altering SQL password by using sp_passoword.

Any user can change his or her SQL user password with sp_password. However, only a System Security Officer who belongs to the Server’s security administrator group can execute sp_password to change another user’s password. Now please first log into SQL Server with Windows authentication mode, then open a new query window and next type the below commands to run sp_password to change password by pressing F5:
sp_password [ [ @old = ] 'old_password' , ]
{ [ @new =] 'new_password' }
[ , [ @loginame = ] 'login' ]

Method 3: Change forgotten SQL Server password with SQL Password Recovery.

It’s easy to change SQL password when you have access to the database. However, what if you lose access to the Server due to SQL Server password is forgotten or lost, how would you change your SQL Server password as easy as method 1 and 2? And is there any chance? Well, a professional SQL password recovery tool can tell you everything. Now please follow me to recover the forgotten SQL password with SQL Password Recovery:
Get SQL Password Recovery here.
Step1: After download the tool, then quickly install and launch it on a computer. Next in the pop-up interface of the tool, click “Open” to load target master *.mdf file.
Step2: After open the *.mdf file, all user names with their passwords will be displayed in a list. Now just select the user account whose password needs to be changed and then click “Change Password”.
Step3: Now enter a new password for this account and then confirm it with clicking “OK” button to change SQL Server password process.

Back to top
 Rate Post
View previous topic :: View next topic  
Post new topic Reply to topic Computers OverClocked Forums - Hardware/Software User Reviews Page 1 of 1

Similar Topics
Topic Author Forum Replies Posted
No new posts Roger Goodell No policy change on nation sherry2018love Site Help and Information 0 Fri Nov 02, 2018 3:35 am View latest post
No new posts How to Recover iCloud Mail Password kellymartina Site Help and Information 0 Mon Sep 17, 2018 6:52 am View latest post
No new posts Change Your Facebook Account Password... williamsmith147 The General Store 0 Tue Jul 10, 2018 12:38 am View latest post
No new posts How to recover I forgot my name and p... nataliasimmons The General Store 1 Thu Jun 21, 2018 5:42 am View latest post
No new posts Dial Toll Free When you Need Gmail Pa... adv2016 The General Store 0 Mon Apr 30, 2018 1:29 am View latest post