Shulou(Shulou.com)05/31 Report--

SQL Server how to use sp_password to reset SA password, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Sp_password

Add or change Microsoft? SQL Server? Login password.

Grammar

Sp_password [] [@ old =] 'old_password',] {[@ new =]' new_password'} [,] [@ loginame =] 'login']

Parameters.

[@ old =] 'old_password' is the old password. Old_password is of type sysname and its default value is NULL. [@ new =] 'new_password' is the new password. New_password is of type sysname and has no default value. If you do not use named parameters, you must specify old_password. [@ loginame =] 'login' is the login name affected by the password change. Login is of type sysname and its default value is NULL. Login must already exist and can only be specified by members of the sysadmin fixed server role.

Returns the code value

0 (success) or 1 (failure)

Annotation

SQL Server passwords can be from 1 to 128 characters, including any letters, symbols, and numbers. The new password is updated and stored in encrypted form, so no user (even the system administrator) can view the password.

When members of the sysadmin or securityadmin fixed server role use sp_password with all three parameters to reset their own passwords, the audit records reflect that they are changing someone else's password.

Sp_password cannot be used for Microsoft Windows NT? Security account. Users who connect to SQL Server through a Windows NT network account are authorized by Windows NT, so their passwords can only be changed in Windows NT.

Sp_password cannot be executed in a user-defined transaction.

Authority

Execute permissions are granted by default to the public role to allow users to change their login passwords. Only members of the sysadmin role can change the login passwords of other users.

Example

a. Change the login password without the original password the following example changes the password of the login Victoria to ok. The copy code is as follows: EXEC sp_password NULL, 'ok',' Victoria'

b. Change password the following example changes the password for logging into Victoria from ok to coffee. The copy code is as follows: EXEC sp_password 'ok',' coffee'

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.