Modify SQL authentication mode and system administrator

1. How do i modify the SQL Server 2000 authentication mode and the system administrator?

Analysis: As a result of thousands of software, in the database security aspects of the safest way "hybrid mode", which is mainly used in the network primarily Novell network or Peer-to-peer network, using the SPX/IP protocol and SQL Server authentication mode.

The advantages are as follows:

Created another security layer on top of Windows nt/2000.

Support a wider range of users, such as non-Windows NT clients, Novell networks, and more.

An application can use a single SQL Server login and password.

Following the example of SQL Server 2000 on the operating system Windows 2000, modify the database that mistakenly selects the authentication mode as Windows Authentication mode:

1. Open Enterprise Manager, expand the server group in turn, and right-click the server that the software uses.

2. On the shortcut menu that pops up, 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 Options box, change Windows only to SQL Server and Windows authentication.

3. When the setup is complete, click "OK" and the system prompts you to reboot the server.

4. Click the Yes button to complete the modification of the authentication mode.

Note: The Windows XP operating system modifies the SQL Server 2000 authentication mode under the Windows 2000 operating system, but under the Windows 98 operating system, the authentication mode cannot be modified using the above methods. Because of the Windows 98 operating system, when you install SQL Server 2000, the system only supports mixed Mode authentication mode.

2. How do i modify the login password for the SQL Server 2000 system Administrator SA?

Analysis: The login password for the SQL Server 2000 system Administrator SA is typically set when you install SQL Server 2000. In the database management system, check the user's identity by means of checking the password, the legal user can enter the database system. Thousand-square series you need to verify the sa login password to create and delete accounts so that the sa login password is particularly important here.

Action steps are as follows:

1. Open Enterprise Manager, expand the server group in turn, and expand the server.

2. Open the Security folder, click Login, and then right-click Sa to perform the Properties command.

3. Eject the SQL Server Login Properties dialog box, as shown in Figure 4. In the SQL Server Authentication password bar, enter the latest password.

4. Click "OK" button, pop-up "Confirm Password" dialog box, and then lose the login password again.

5. Click "OK" button to complete the change to the sa login password.