SQL Server2005 to set logins as Windows and SQL Server mixed logins

Server|window sqlserver2005 The default is Windows authentication after installation, you can change to mixed logins in the following ways. first log on to SQL Server with Windows Authentication, right-click on the SQL Server instance field in Object Explorer, select Properties, and select Security in the Properties dialog box. Select SQL Server and Windows Authentication Mode in the Security dialog box, and click OK. If you want to log in with the SA user, you can simply modify the SA user password. If you want to create a new user, back to the SQL Server instance field in Object Explorer, click the right mouse button and select New query, and the SQL edit box appears in the edit box, which creates a logon user and password for SQL Server server authentication in the statement. Created SQL statement: Create LOGIN jywhu with password= ' 123 '; then click Execute on the edit box. If the execution succeeds, create a username that is jywhu, and the password is a 123 login account. This account is then set up as a server role so that you can log in to create and delete databases and data tables, as well as in the SQL Editor just now. Set the SQL statement: Execute sp_addsrvrolemember ' jywhu ' sysadmin; then click Execute. If you want to remove its server role: Execute sp_dropsrvrolemember ' jywhu ' sysadmin; execution is ok.