Shulou(Shulou.com)06/01 Report--

Xiaobian to share with you how sqlserver to view sa password, I believe most people do not know how, so share this article for your reference, I hope you read this article after a great harvest, let us go to understand it!

How does sqlserver view sa password?

How to view sqlserver sa password and steps:

1. Log in to the system using Windows identity instead of password.

2. After entering sql server 2005, right-click on the service name to select properties, select sql server and windows identity mode in security, and click OK.

3. Double-click on sa as shown in the figure, and modify the password at the position as shown in the figure. Generally, it is best to use a combination of letters and numbers, so as not to have 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 restart it, and 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 from objects, provides fine-grainAccess access, and allows greater control over data access. In addition, all system tables will be implemented as views, giving you greater control over database system objects.

SQL Server2005 provides new language capabilities for developing scalable database applications. These enhancements include error handling, recursive query functionality, relational operators PIVOT, APPLY, ROW_NUMBER, and other data column ranking capabilities.

With SQL Server2005, 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 access capability for Web service center applications.

The above is "sqlserver how to view sa password" all the content of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

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.