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
  • AVEVA Historian
  • AVEVA Historian Tech Notes

TN 1437 How to resolve Historian error: "The SQL login is invalid. Please update the Server startup options."

Last updated: February 20th, 2025

Description

  • Author: Ernest Lee
  • Published: February 20th, 2025

Details:

Description

  • Author: Ernest Lee
  • Published: March 25, 2024
  • Applies to: Historian version 2017 and later

Details

This article from InSource shows how to resolve the Historian error "The SQL login is invalid. Please update the Server startup options."

  1. In Historian, right-click Management Console and choose Shutdown (and disable Historian
  2. Open SQL Server Management Studio, navigate to Databases - Runtime - Security - Logins and delete all ArchestrA logins via example:
    EL_SP2k23_W2019\aaAdministrators - EL_SP2k23_W2019\aaPowerUsers - EL_SP2k23_W2019\aaUsers
  3. In SSMS navigate to Databases - Runtime - Security - Users and delete the users selected below.
  4. Next open Configurator and select Security on the left and click Configure to establish Historian security.
  5. Next navigate to C:\Program Files (x86)\Wonderware\Historian\x64 and right-click aahSecurity.exe and Run as Administrator.
  6. Navigate to C:\ProgramData\ArchestrA\Historian\Install\Scripts and double-click the SQL script RuntimeSecurity.sql and run it in the SSMS interface.
  7. Go back to the Historian and this time click Enable (allow to run) Historian.

 

invalid resolve
Give feedback about this article

Recommended articles

TN - 1240 Creating a Watchlist Using an Import File

Read More

TN 1242 Aveva Historian Storage Locations and Best Practices

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