Facbook Pixel

Change SQL Server to Mixed-Mode Authentication

If you're trying to add MS SQL Web or Standard to your server, you must change your installation to allow both Windows and SQL authentication because Plesk cannot use Windows authentication to read SQL Server.

  1. While logged into your server with Remote Desktop, open SQL Server Management Studio.
  2. Connect to your SQL Server using your Remote Desktop credentials. These will be pre-loaded by default.
  3. On the left-hand side, right-click your server name, and click Properties.
  4. Select Security from the left-hand menu.
  5. Select the radio button for SQL Server and Windows Authentication mode.
  6. Click OK. You will get a message saying that the service must be restarted.
  7. From the Start menu, open Administrative Tools.
  8. Open Services.
  9. Right-click on SQL Server, and click Restart.

Next step