Got it

How to Change the sa Password of the SQL Server

Latest reply: Aug 18, 2019 10:21:15 368 1 1 0 0

Hello, I'm going to share with you how to change the sa password if you forget to set the password during the installation or if you want to change the password.


The operation is simple.


Step 1 Select Start > Programs > Microsoft SQL Server > Enterprise Manager.The SQL Server Enterprise Manager window is displayed.

CAUTION:

If the U2000 is already installed on the current server, modify the sa password of the SQL Server database through the NMS maintenance tool. For details, see Changing the Password of the sa Database User.


Step 2. In the navigation tree, expand the database server group node, database server node, and security node in turn, and click Login.


Step 3. Double-click the sa user in the right pane. In the dialog box that appears, modify the sa password, and click OK.


Step 4.  In the dialog box that appears, enter the new password again, and click OK.


 


How to update changed password in BMU and AppAgent ?
View more
  • x
  • convention:

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.