• FAQ
  • Manuals
  • Knowledge Base
  • Videos
  • Downloads
  • FAQ
  • Manuals
  • Knowledge Base
  • Videos
  • Downloads
What's Popular:quick test, wifi, syncing

Database Connection

image_pdfimage_print

Introduction

On occasion, customers will see a message stating “Cannot Connect to Database” or receiving a username and password prompt when starting the software. This is caused when SureTrend can no longer access  the SQL database.  The most common causes are if the Database has been  renamed or the location of   the database has been changed. Make sure all users of  SureTrend software have Read/Write permission to the folder that contains the Database.  If you do not have proper access contact your IT department. 

 

Solution

If this is affecting a new SureTrend user who has no data in the application then the software was most likely installed with the “Multiuser – Distributed” checkbox selected. Have the customer uninstall the software and reinstall it without checking the “Multiuser – Distributed Network”    Complete instructions on a standard  installation  can be located here: https://help.hygiena.com/kb-doc/s4-standard-installation/

If this is affecting a current SureTrend user and the database exists on a network drive then the path to the SQL database or its name most likely changed. Have the user change the name of the database back to what it was originally, or move the file back to where it was before.   Alternatively you can direct the SureTrend 4 software to the correct file location (Read/Write access is mandatory in order to access the database and Sync your data)  Go to the “Admin” tab then select” Server Configuration Setting” and type in the correct database file location.

If this is affecting a current SureTrend user and the database exists on a network with a distributed setup then they need to make sure that the network is accessable  and operating normally. They will have to contact their IT group to check on this or fix the issue. Read/Write access is mandatory for the SureTrend 4 software to work properly.

If this is affecting a current SureTrend user and the database exists on SQLServer then they need to make sure that they have read-write access to the location of the SQLserver.  They will have to contact their IT group to check on this or fix the issue. Read/Write access is mandatory for the SureTrend 4 software to work properly.

 

If the user does know where the SureTrend.sdf file is located or is not sure of the name they should search for it in the windows explorer app by typing *.sdf to find all instances of possible database locations on their system.

Tags:connectiondatabaseloginserverusername and password
Related Articles
  • How to Erase Results on EnSURE and SystemSURE Plus
  • Using Teamviewer to Receive Remote Support
  • Multiuser Distributed Network Installation
  • Network Share Installation
  • Standard Installation
  • Updating an existing Suretrend 4 software installation to the latest version.
SureTrend 4
  • Database Connection
  • How to Erase Results on EnSURE and SystemSURE Plus
  • Using Teamviewer to Receive Remote Support
  • Multiuser Distributed Network Installation
  • Network Share Installation
  • Standard Installation
View All 9  
Popular Articles
  • Connecting to Wi-Fi
  • Importing Programming Information Into SureTrend Cloud
  • Getting Started with EnSURE Touch
  • Calibration Checks on the EnSURE Touch
  • USB Tethering Configuration
KB Categories
  • ATP
    • Microbial Detection
  • CalCheck
  • Connectivity
  • EnSURE and SystemSURE Plus
  • EnSURE™ Touch
  • Getting Started
  • Hardware
  • Hygiena Academy
  • Reagents, Tests and Devices
  • SureTrend 4
  • SureTrend Cloud
  • SureTrend CloudSync
About Hygiena Help

We stand behind the quality of our products and are committed to our customers. That is why we’re proud to offer world-class support.

Recommended
  • Performing a Quick Test
Most Popular Articles
  • Managing the Security Feature for Ensure Touch™ from the Cloud
  • CalCheck Negative Control Failing
  • Blurred or Distorted EnSURE Touch Screens
  • Excluding Plans and Locations on EnSURE Touch
Latest Articles
  • Moving the Database
  • Server Installation
  • Connecting to Wi-Fi
  • Performing a Quick Test
  • © 2021 Hygiena, LLC.. All Rights Reserved.