Home Guides Glossary

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

Domain Registration

Pay less for website domain names. Register your own .com, .net or .org for as low as $10.18 per year. We have everything you need to get online with your new domain.

Website Builder

For as little as $3.89 per month you can build your Website online with Website Builder using our easy to use professional templates. Play Video - Demo

Quick Shopping Cart

Build and run your own successful online store in minutes. You're just five easy steps away! Shopping Cart works with Google® and eBay® Play Video

Website Hosting

Everything needed to give your website the high-performance home it deserves.  Protect transactions and secure your customer's data with a SSL Certificate

Copyright © 2005 - 2017. All rights reserved. Privacy Policy