Table of Content

How do I activate mixed authentication mode in Microsoft SQL Server?

We recommend creating a dedicated database user for creating and updating databases for d.velop products.

To create users in Microsoft SQL Server, select the server authentication mode SQL Server and Windows Authentication Mode when installing Microsoft SQL Server. You can check and change the setting in SQL Server Management Studio.

This is how it works

  1. Right-click on the server in the Object Explorer and select Properties.
  2. Select the option SQL Server and Windows Authentication Mode on the page Security under Server authentication and save with OK.
  3. In the object explorer, right-click the server and select Restart to apply the changes. If SQL Server Agent is running, restart the service as well.