How to set up or change the authentication mode for MSSQL

To set up or change the authentication mode for MSSQL (Microsoft SQL Server), follow these steps:

Step 1: Open SQL Server Management Studio (SSMS)
- Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance.

Step 2: Access Server Properties
- In Object Explorer, right-click on the server name and select Properties.

Step 3: Modify Security Settings
- In the Server Properties window, click on the Security tab.
- Under Server Authentication, you will see two options:
  - Windows Authentication mode (default)
  - SQL Server and Windows Authentication mode (Mixed Mode)
- Select the desired authentication mode.

Step 4: Save Changes
- After selecting the authentication mode, click OK to save the changes.

Step 5: Restart SQL Server
- For the changes to take effect, you need to restart the SQL Server service. To do this:
  1. In Object Explorer, right-click on the server name and choose Restart.
  2. Confirm the action in the pop-up window.

Step 6: Verify the Change
- Once SQL Server restarts, the authentication mode will be updated. You can verify this by reconnecting to the server and attempting to log in using the appropriate credentials for the chosen mode.

You have now successfully changed the authentication mode for MSSQL.

Thanks for visit my website