Got it

Huawei Enterprise Support Community

Community Forums Network Manager&SDN

How Do I Change the Passw...

How Do I Change the Password of the sa User of the SQL Server Database?

Created: Mar 28, 2016 04:51:51Latest reply: Mar 28, 2016 07:10:24 1044 1 0 0 0

View the author ^1#

How do I change the password of the sa user of the SQL Server database?

x
convention：
Emotion(0)

Like (0) Dislike (0) Favorite(0) Report

 Previous: Can the eSight Installation Directory Be Shared in the Windows Operating System?

Next: eSight performance graphs were deleted because insufficient memory

(0) (0)

^2#

Rickymoon Created Mar 28, 2016 07:10:24

1. Start the command-line interface, log in to the SQL Server database as the sa user (the password is password), and view the computer name.

osql -Usa –Ppasswordsp_password null, 'New password'goexit

2. When the password is changed, run the following command to log in to the SQL Server database:

If the login succeeds, the password is changed successfully.

osql -Usa –PNew password

View more

x
convention：

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

Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.

Please bind your phone number to obtain invitation bonus.