How to Enable sa User for SQL Server 2019 using SSMS?

The actions listed below can be used to enable SA user for SQL authentication:

1. Click on the Windows icon on your desktop and click on SQL Server Management Studio to open it.

2. After that, a popup to connect to the server will appear. Click Connect here.

3. Click the + icon next to the Security option to make it larger. Click the plus icon next to the Logins option to make it larger still.

4. Here, you can see that the sa user is marked with a red-cross that means the login for it is disabled. Right-click on sa and click on Properties.

5. In the Login Properties window, click on Status from the left-panel and select Enabled option under Login. Then click on OK.

6. To confirm if the sa user is enabled for SQL Authentication, you can Disconnect the server by right-clicking on the server and then clicking on Disconnect. From the Connect drop-down under Object Properties click on Database Engine. This will open a dialog for Connect to Server, here click on Connect.

7.Next, carry out step three again. You will notice that the red cross that was previously visible on SA has vanished under Logins. This indicates that the user has permission to log in.

It may also be necessary for you to set a password for the system administrator account at this point.

You can use SSMS to enable a user for SQL Server 2019 in this manner.
How to Add a Site Redirect in DirectAdmin?