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
Navigate to your SureTrend 4 database. By default, it is located at1.
C:\ProgramData\Hygiena\SureTrend
If you do not see your ProgramData folder, open File Explorer. Click View2.
and check Hidden Items in the Show/Hide tab.
Copy the *.sdf database file and paste it in another location outside of this3.
folder.
Install the Current Version of SureTrend 4
Download the most recent version of SureTrend 4 here.1.
Run the installer, select you preferred language, and click Next.2.
For a standard installation leave the Multiuser Distributed Network3.
checkbox unchecked.
For a Multiuser Distributed Network using internet information services4.
check the checkbox. (Rare)
Click Finish and launch SureTrend 4.5.
Click Yes when prompted to update the database.6.
You should be able to sync any new instruments to SureTrend 4 now.7.
Contact Hygiena Technical Support for further assistance.
Phone: 1-888-HYGIENA (1-888-494-4362, option 2)
Email: [email protected]
Submit a Support Ticket
Schedule a Microsoft Teams meeting with support
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
