Database Connection

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

Updating SureTrend 4

Introduction

This article will provide step-by-step instructions on how to back up your database and install the current version of SureTrend 4.

Solution

To verify your version of SureTrend 4, check the About section under the Admin tab.  The current version of SureTrend 4 is 4.0.3.4 – Build 11.  If you do not have the current version, proceed with the following steps.  If you have the current version, your syncing problems are related to another issue.  Contact Hygiena Technical Support using by clicking here.

Create a Copy of Your SureTrend 4 Database

  1. Navigate to your SureTrend 4 database. By default, it is located at C:\ProgramData\Hygiena\SureTrend
  2. If you do not see your ProgramData folder, open File Explorer. Click View and check Hidden Items in the Show/Hide tab.

  3. Copy the *.sdf database file and paste it in another location outside of this folder.

Install the Current Version of SureTrend 4

  1. Download the most recent version of SureTrend 4 here.
  2. Run the installer, select you preferred language, and click Next.
  3. For a standard installation leave the Multiuser Distributed Network checkbox unchecked.
  4. For a Multiuser Distributed Network using internet information services check the checkbox. (Rare)
  5. Click Finish and launch SureTrend 4.
  6. Click Yes when prompted to update the database.
  7. You should be able to sync any new instruments to SureTrend 4 now.

Contact Hygiena Technical Support for further assistance.

Moving the Database

Before You Begin

  • If you plan on moving your database to another machine running SureTrend, be sure to install SureTrend on the new machine first.
  • You will need a USB drive or cloud storage in order to transfer the database from the old machine to the new one.
  • You can only change your SureTrend database location if it is not in a multiuser mode (i.e. not set to SQL Server or Distributed).
  • If you plan on moving your database to a networked location to share with multiple people be sure all users have the correct permissions to access this area.

Getting Started

Step One: Copying the database
Click to enlarge

Open File Explorer and navigate to C:\ProgramData\Hygiena\SureTrend. If you do not see the Program Data folder type the bold text above into the address bar. In the example to the left the address bar is highlighted in yellow.

Select the suretrend.sdf file and copy it.
Step Two: Adding the database to the new location
Click to enlarge Navigate to the new location you would like to place the database file and paste the suretrend.sdf file there.

If the location is a new computer make sure to install SureTrend on it first. A USB drive or other portable media may be required to transfer the database over.
Step Three: Updating SureTrend settings
Click to enlarge Start SureTrend and click on the Admin tab at the top. Click on Server Configuration Settings in the left list of tabs. Change the Database Name by clicking the three dots and navigating to the new location you pasted the suretrend.sdf file. Click Save and restart SureTrend.
Step Four: Cleanup
Click to enlarge You may now go back to the old database location and delete the suretrend.sdf file there as it is no longer being used.

Share the new SureTrend Database Name location with everyone else that will need it. They will need to follow step 3 to connect to the database.

 

database, move, move suretrend database, moving, moving database, moving suretrend database