VPS og Dedikerte servere (Mine servere) Hjelp

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


Var denne artikkelen nyttig?
Takk for din tilbakemelding. For å snakke med en representant fra kundeservice, bruker du telefonnummeret til støtte eller chatte-alternativet ovenfor.
Vi er glade for å kunne hjelpe deg! Er det noe annet vi kan gjøre for deg?
Vi beklager det. Fortell oss hva som var forvirrende eller hvorfor løsningen ikke løste ditt problem.