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.)

TN PT120 Enabling SA Account in SQL Express

Last updated: March 3rd, 2025

Description

  • Author: Brian Schneider
  • Published: March 3rd, 2025

Details:

Description

How to enable the SQL SA account in SQL Express after a Wonderware System Platform install

  • Author: Mike Viteri
  • Published: 9/7/2017
  • Applies to: SQL Server

Details

  1. Open SQL Server Management Studio.
  2. Under Security->Logins. Find the SA Account. It is disabled by default. You should see a down arrow next to it.
  3. Right click on the SA account and go to properties. Select the Status page. You will see Login: This should be set to Disabled. Set it Enabled.
  4. Go back to General under select a page. You can now reset the SA password.
  5. Now right click on your SQL Server. Go to Properties.
  6. Select Security. You should see Windows Authentication mode selected. Change this to SQL Server and Windows Authentication mode.
  7. Now you get a message you have to restart SQL Server.
  8. Reboot your computer.
enable sql
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