MSSQL-Create a new user

1. Login using Windows authentication first.

2. Then open it once: security---> Logins, right-click Logins, tap New login.

3. Under the General tab: Fill in the Login name, select SQL Server Authentication, fill in the login password, cancel the Enforce password policy, select the default database.

4. Server role tab: Select Server role.

5. User Mapping Tab: Select the database membership to which this created user is mapped.

6. Status tab:

7. After that, click OK, then right click on the server name and select Properties. ：

8. Under Security tab, SQL Server and Windows Authentication mode.

9, click OK, use "Win key +r", open the running window, and enter cmd, then click OK.

10, enter services.msc in the command window, then return.

11. After carriage return, open the service window. After you select the SQL Server (SQLEXPRESS) service, shut down, and then restart.

At this point, restart SQL Management Studio and you can then log in with the newly created user.

MSSQL-Create a new user