This article is a continuation of my previous article and I have provided a link for that article. From this article, let’s see how to configure SQL Server for mixed mode for authority (authentications).
Prerequisites
An active Azure subscription with SQL Server 2016 SP1 running on Windows Server.
SQL Server 2016 on your PC.
Configure SQL Server in mix mode authority
To connect to the database engine from another PC, we need to configure the mix mode authentication, where it leads to authentication of both SQL Server & Windows authentication.
Now, let’s get started
To connect to the virtual machine, click->start->SQL Server Management Studio.

From SQL Server Management Studio Window, Object Explorer right click->name of virtual machine SQL Server->click->Properties.
From Security page and in Server authentication-> select SQL Server and Windows authentication mode. Click OK.
The Server needs to be restarted. For this right click, VM SQL Server, click Restart.
Creating SQL Server authentication rights
We need a minimum of one SQL Server authentication login for connecting DB from another PC.
In SQL Server Management Studio, right click security folder ->new->login.
In login new dialog box, enter the name of the user and select SQL Server authentication. We need to provide the password for the user.
By providing the password enforcement option, we can select the enforce password policy and enforce password expiration. You can select the user who must change password at next login.
In the default DB, the master will be default and the language will be default.



Join the conversation! Your thoughts help the community grow.