[ISS Support Case] OMI SQL Data Grid Does not work with SQL authentication
Last updated: October 17th, 2025Description
Ref previous case 80195 Imported the Data Grid as an OMI App from C:\Program Files (x86)\Archestra\Framework\Bin\Invensys_Systems_inc_SQLDataGridUserCtrl.dll The data grid works as expected when using Windows Authentication but does not work with SQL authentication. Validated sql login with .UDL test and logging in with the desired sa account in SSMS. Validated the behavior is the same on my system even when using the SA account. In the Grid the error message is "Login failed for user 'sa' Invalid connection string attribute No records returned" In SQL Server Log the error message is "Login failed for user 'sa'. Reason Password did not match that for the login provided [CLIENT: ] Error 18456, Severity. 14, state 8"
- Author: Kevin Modlin
- Published: October 17th, 2025
Details:
| Product: InTouch OMI |
| Version: 2020 R2 |
| Solution: [Solution is visible below when you're logged in and have a current subscription] |
| Date Created: | 02/08/2022 |
| Case: | 80866 |
Give feedback about this article
Recommended articles
[ISS Support Case] Trend not showing correct data from the previous day
Production machine that's been in production for a while Noticed the issue on the 20th They are unaware of any changes that could have caused the issue
Read More[ISS Support Case] OMI MapApp Configuration
Client reached out looking for guidance on configuring the MapApp.
Read More[ISS Support Case] Trend SQL DB Connection Issue
Client reached out due to receiging the following error when trying to login/connect to SQL DB within OMI Trends: "System.Security.Cryptography.CryptographicException: Key not valid for use in specified state."
Read More[ISS Support Case] OMI Alarm Client Not Re-Querying Properly
I am having a really hard time understanding why my alarm query is not updating according to the script I wrote up. I have a script that should change how the alarm client is queried based on the current navigation. It updates the query accordingly when I navigate from one layout to another. However, when I navigate from one screen to another (that uses the same layout), the alarm query refuses to update!
Read More