Modification of Microsoft SQL Server Authentication Method

Windows authentication is usually used when Microsoft SQL Server is installed, but Hybrid Authentication is often required in application development. After installation, you can modify the authentication as follows:

1. Modify the authentication method

Open Microsoft SQL Server Enterprise Manager, expand the database, right-click the server name (usually local), select "properties", and select the "Security" tab, change the authentication method to "windows and SQL Server Hybrid Authentication mode.

2. Edit registration attributes

Right-click the database server, select "Edit SQL Server Registration attributes", select Hybrid Authentication Mode on the pop-up interface, and enter the user name and password.