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

In this issue, the editor will bring you about how to change the sa password in the sql database. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

1. How to modify the SQL Server 2000 authentication mode? Analysis: due to all kinds of software, the safest "mixed mode" is adopted in database security, which is mainly used in Novell network or peer-to-peer network, using SPX/IP protocol and SQL Server authentication mode. The advantages are as follows: another security layer on top of Windows NT/2000 has been created. Support a wider range of users, such as non-Windows NT customers, Novell networks, etc. An application can use a single SQL Server login and password. Take SQL Server 2000 on the operating system Windows 2000 as an example to modify the database that mistakenly chose the authentication mode as "windows authentication mode". The steps are as follows: 1. Open the enterprise manager, expand the server group, and right-click the server used by the software. 2. In the pop-up shortcut menu, execute the Properties command, and the SQL Server Properties dialog box appears. As shown in figure 3. Click the Security tab, and in the Security option box, change Windows only to SQL Server and Windows authentication. 3. When the setup is complete, click the OK button and the system prompts you to restart the server. 4. Click the Yes button to complete the modification of the authentication mode. Note: the authentication mode of SQL Server 2000 modified in Windows XP operating system is the same as that in Windows 2000 operating system, but in Windows 98 operating system, the authentication mode cannot be modified by the above methods. Because under the Windows 98 operating system, when installing SQL Server 2000, the system only supports mixed mode authentication mode.

2. How to change the login password of SQL Server 2000 system administrator Sa? Analysis: the login password of SQL Server 2000 system administrator Sa is generally set when installing SQL Server 2000. In the database management system, only legitimate users can enter the database system by checking passwords and other means to check the user's identity. All kinds of medicine series need to verify the Sa login password to create and delete account sets, so the Sa login password is particularly important here. The steps are as follows: 1. Open Enterprise Manager, expand the server group, and then expand the server. 2. Open the Security folder, click Login, and then right-click Sa to execute the Properties command. 3. The SQL Server login properties dialog box pops up, as shown in figure 4. In the SQL Server Authentication password bar, enter the latest password. 4. Click the "OK" button, pop up the "confirm password" dialog box, and type the login password again. 5. Click the "OK" button to finish changing the Sa login password.

The above is how to change the sa password in the sql database shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow 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.