Some content on this site is available only to logged-in subscribers. Contact Us for information on becoming a subscriber.

InSource.Solutions | InSource Training | InSource Client Portal
InSource Solutions Logo
Log In Sign Up
InSource.Solutions InSource Training InSource Client Portal Log In Sign Up
  • Home
  • Supporting Technologies (i.e. Windows / SQL Server / VMWare / etc.)
  • Supporting Technologies Tech Notes

Setting SQL Server to use Mixed Mode/SQL Authentication

Last updated: February 20th, 2025

Description

  • Author: Brian Schneider
  • Published: February 20th, 2025

Details:

Description

If during SQL Server installation it was chosen to only use Windows Authentication instead of Mixed Mode Authentication, many products will be unable to connect to SQL Server.

Before you Begin

This document assumes SQL Server has already been installed. If not, find our tech note on installing SQL Server, and the steps included in that document will ensure you have the correct setup.

Pre-Requisites

During the SQL Server installation you must have allowed at least one Windows user to have access to SQL Server and be able to log into SQL Server using this account. If this has not been done, you will need to reinstall SQL.

Detailed Steps

  1. Open SQL Server Management Studio by going to Start > Programs > Microsoft SQL Server YEAR > SQL Server Management Studio.
  2. Log in with Windows Authentication with an administrative account.
  3. Change the authentication
    1. On the Object Explorer window right click on the server name and go to Properties.
      1. Select the Security section.
        1. Under Server Authentication change the selection from Windows Authentication mode to SQL Server and Windows Authentication mode.
        2. Click Ok
      2. Click Ok
  4. Enable the sa login:
    1. In Object Explorer expand the Security folder, and the Logins.
    2. Right click sa and go to Properties.
      1. On the General tab set the password you want to use.
      2. On the Status tab, in Login set it to Enabled.
      3. Click OK
  5. Restart SQL Server:
    1. Right click on your Server name in Object Explorer
    2. Select Restart
mixed mode authentication
Give feedback about this article

Recommended articles

How to receive group emails

Read More
Support Icon

CONTACT SUPPORT

How to reach us

10800 Midlothian Turnpike Tpke, Suite 209, Richmond, VA 23235

1.877.INSOURCE

Technical Support - 1.888.691.3858

Contact Us

  • InSource Solutions
  • InSource Training
  • InSource Client Portal
  • Log In
InSource Solutions Logo

© 2025 InSource Solutions. All Rights Reserved.

Knowledge Base Software powered by Helpjuice

Expand