Updated Articles

  1. How to restore a database backup to SQL Server

    Last Updated: 06/05/2025 in OnGuard Ecosystem Database SQL
     How to restore a database backup to SQL Server  Procedure Steps 1) Install OnGuard, SQL Express, and Microsoft SQL Server  Management Studio. Microsoft SQL Server Management Studio and SQL Express can  be downloaded from Microsoft a...

  2. How to change the Lenel database password

    Last Updated: 06/05/2025 in OnGuard Ecosystem Database SQL
    How to change the Lenel database password Procedure Steps 1) Click the Start button, then select Programs > Microsoft SQL Server xxxx > SQL Server Management Studio . 2) Log into SQL Server Management Studio. 2) In the Object Explor...

  3. How to perform a clean uninstall of Microsoft SQL Server

    Last Updated: 06/05/2025 in OnGuard Ecosystem Database SQL
    How to perform a clean uninstall of Microsoft SQL Server Procedure Steps Important: Modifying the registry could cause irreversible damage to your Windows operating system; be sure to back up the registry before making any changes. Follow...

  4. ''Cannot open backup device'' message when trying to back up SQL database

    Last Updated: 06/05/2025 in OnGuard Ecosystem Database SQL
    Symptom When running Database Backup in SQL Server the following error message appears: "Backup failed for server "XXXXXX". (Microsoft.SqlServer.Express.Smo)" Additional Information: System.Data.SqlClient.SqlError: Cannot Open Backup Device...

  5. In SQL Server Management Studio, why is there a red arrow pointing down in the icon next to a login?

    Last Updated: 06/05/2025 in OnGuard Ecosystem Database SQL
    Question In SQL Server Management Studio, why is there a red arrow pointing down in the icon next to a login? This icon can be found in the Object Explorer. Expand Security , then expand Logins , and note that one or more of the login icons...

  6. AccessControl database not available in ODBC DSN, or unable to sync Login Driver password, after database restore

    Last Updated: 06/05/2025 in OnGuard Ecosystem Database SQL
    Symptom You may encounter the following issues after restoring a backup of the AccessControl database into an OnGuard system running SQL Server: - When configuring or testing the ODBC DSN, the AccessControl database is not listed in the Chan...

  7. Error connecting to SQL Server: ''Error: 26 - Error Locating Server/Instance Specified''

    Last Updated: 06/05/2025 in OnGuard Ecosystem Database SQL
    Symptom When connecting to SQL Server, whether from the ODBC DSN or another method, you may experience all or part of the following error message: An error has occurred while establishing a connection to the server. When connecting to SQL Ser...

  8. How to determine if you are running SQL Express or Standard

    Last Updated: 06/05/2025 in OnGuard Ecosystem Database SQL
    How to determine if you are running SQL Express or SQL Standard Procedure Steps In SQL Server Management Studio, run the following query:   SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('editio...

  9. How to modify the server name in SQL Server

    Last Updated: 06/05/2025 in OnGuard Ecosystem Database SQL
    How to modify the server name in SQL Server Procedure Steps NOTE: Please be sure to back up the Master and AccessControl databases before proceeding. To update the name do the following: 1) Open the Microsoft SQL Server Management Tool....

  10. SQL Server Data Source drivers used with OnGuard

    Last Updated: 06/05/2025 in OnGuard Ecosystem Database SQL
    Symptom  SQL Server Data Source drivers used with OnGuard  Resolution  OnGuard 7.3 and earlier installed with SQL Server requires that SQL Server Data Sources use the SQL Server Native Client 11.0 driver . OnGuard 7.4 and later installed with ...
© 2024 Honeywell International Inc. All Rights Reserved.
Privacy Statement | Your Privacy Choices | Cookie Notice