Enable Mixed Mode Database Authentication
In creating the setup for the store database, we can configure the SQL Management Studio to enable dual authentication for the database user.
Although Windows Authentication is set as the default mode of authentication during initial setup, we strongly recommend setting SQL Authentication as the standard mode of authentication for a more secured connection to the database.
To enable the Mixed Mode Authentication for the database,
- Open the SQL Management Studio. Enter the credentials to connect to the store database.
- In the Object Explorer section, right click on the sql instance name. From the pop-up menu, select Properties option.
- The Server Properties window will be displayed. In the Select a Page section, click on the Security option.
- Under the Server Authentication section, select SQL Server and Windows Authentication mode. Click OK.
