How to check sa password in sqlserver

How to check sa password in sqlserver?

Methods and steps to check the password of sqlserver sa:

1, use windows identity to log in to the system, no password is required

2, after entering sqlserver2005, right-click on the service name and select properties, select sql server and windows identity mode in security, click OK

3, in the following Double-click on the sa as shown in the picture, and change the password in the position shown in the picture. Generally, it is best to use a combination of letters and numbers to avoid having to do it again if it is not easy to use. Click OK

5. In the interface as shown in the figure, stop the service and then restart it to return to the sqlserver login interface. Change to sa login and enter the newly modified password

Extended information

The new security model in SQL Server2005 separates users and objects and provides fine-grainAccess access, and allows greater control over data access. Additionally, all system tables will be implemented as views, providing greater control over database system objects.

SQL Server2005 provides new language functions for the development of scalable database application software. These enhanced performance include error handling, recursive query capabilities, relational operators PIVOT, APPLY, ROW_NUMBER and other data column ranking capabilities.

With SQL Server 2005, developers will be able to develop Web services at the database layer, treat SQL Server as a Hypertext Transfer Protocol (HTTP) listener, and provide a new type of data for network service center applications. access function.

Recommended mysql video tutorial, address: https://www.php.cn/course/list/51.html

The above is the detailed content of How to check sa password in sqlserver. For more information, please follow other related articles on the PHP Chinese website!