TMS checks whether the configured SQL Server is running or
available and if this is not the case you get this message.
Unavailability of the SQL Server running your TMS database can be
caused by the following:
- Incorrect TMS configuration; check the server name with your
local IT department and correct it with the DbConnectCfg.exe
program (supplied with TMS).
- The SQL Server name is correct but the service is turned off
(can be the case with a locally installed MSDE). In this case
TMS can start SQL Server when you start TMS. Use the
DbConnectCfg.exe program and set the option 'Start SQL service
- The configuration is correct but the LAN or the SQL Server
is down. Contact your local IT department to report the problem
and wait until they have solved it.
When I start TMS message 'Error# -2147024891 in
OSOSQLL@TSQLServer::ServerStart(). [SQL-DMO] Service control error:
Access Denied' appears. But when I click [OK] everything works just fine.
Your TMS configuration has the option 'Start SQL service with
application' enabled but your UserID is not allowed to start or stop
the SQL Service. Turn off the 'Start SQL service with application'
option with the DbConnectCfg.exe program.
Your TMS configuration has been set to a TMS database (in the
screenshot TMSFEP) that either doesn't exist or that you don't have
access to. Make sure the database name is correct and that your
UserID, direct or indirect via a security group, has been granted
access to the SQL database and is part of the TMSUserRole.
At start-up TMS checks it's program version against the version
stored in the TMS database. If the major and minor version numbers
do not match you get the message above. TMS checks these numbers to
prevent users from working with older or newer software than the
database is designed for. This prevents weird error messages and
program crashes and, in a worst case, even data corruption. When you
upgrade the software you must also upgrade the database and vice
versa. Contact Object Software on how to resolve this.
How to reset TMS
to its initial settings
When you start the TMS with the command line parameter /setdefaults
or /sd (for example c:\program files\TMS\tms.exe /sd) it
triggers the procedure that will delete all custom TMS settings on
your workstation and enter default values into the TMS database.
Please note that your default lend time will be reset to 720
hours (=30 days) and the numeric employee code padding length is
reset to 6 positions. The usage statistics will also be reset.
parameter only when for instance TMS crashes due to a corrupt
registry or when someone (not using TMS) has deleted system types
like 'STOCK' and 'Undefined'.
to re-register a TMS license
My company has increased the number of workstation licenses but
how do I install this new license?
When TMS is first started the software prompts for the
registration name and activation code. To change the registration
name/activation code afterwards (after it has been registered in the
past) you can start the program with the command line parameter
/register or /r (for example c:\program files\TMS\tms.exe
/register). It will then again prompt for the registration name and
When you want to transfer data from the Formula barcode reader to TMS you
get the message 'Error 122:0 During reader access' and then the
message 'Not connected' and nothing is transferred.
When you get this message TMS cannot communicate with your
barcode reader. The following can cause this:
- Most likely you have selected the wrong COM port. Select
File>Configuration, tab 'Barcode', section 'Reader' and check
the COM port. It must be set to the port the cradle has been
connected to. Also check the speed setting: this must be set at
- The cradle is turned off. When the led on the cradle is not
lit green or red it is turned off. Turn it on with the on/off
switch on the right side.
labels and reports don't show barcodes
Problem: When you print a barcode label or a report
containing barcodes like the 'Barcode list of lends per employee'
report, no barcodes are shown. Only the code itself with a rather
Cause: In some cases the installation program doesn't register
the Code 3 of 9 barcode font properly.
Solution: reinstall the barcode fonts using the control
panel fonts section. Choose 'install new font' from the menu and
browse to the \Additional\Fonts folder of the TMS installation CD.
Check the 'copy font to windows fonts directory' option and click
You can move around tools using drag and drop. To lend a tool
open the 'lendings overview' screen and select the person you want
to lend the tool to. Now open the stock overview and select the tool
you want to lend. Now click and the tool and drag it over to the
lend to ... listbox that contains the tools the person you want to
lend the tool to and drop it into that window. TMS will request a
confirmation for the move.
Click [OK]. If the
tools is not serialized you can now enter the number of items you
want to lend.
To return a tool you can use the same drag and drop method but
you can also click on the [Return] button to return it to stock.
In the first weeks after TMS is introduced people tend to scan
all sort of things with the barcode scanner. They also will make
more mistakes in the beginning and that results in a lot of bogus
People will always make mistakes while working with the barcode
readers and the TMS itembag screen will help you solve these errors
as much and easy as possible. One of the features is the 'blanks' or
garbage filter option where TMS will check all transferred barcode
transactions and judge whether a transaction is (partly) valid or
not. In this way blank and bogus transactions can be removed with a
few mouse clicks after which you can focus on the real mistakes that
have been made.
To use the blanks option: After barcode transactions transfer,
select the [Blanks] button on the button bar on the right of the
Itembag screen. Deselect the transactions that you want to keep by
clicking on the checkbox before each line. Click [Discard] in the
toolbar to delete the selected bogus transactions.
print barcodes for multiple tools at once?
With TMS you can
easily print a barcode label for a tool. Select the tool you want
the label for and click on the [Barcode] button in the toolbar. Or
when you add a tool to the stock - using 'Add items to stock' - you
can immediately print a barcode label for the tool you just added.
This will give you one barcode at the time.
But you can also print a series of barcode labels in one go. This comes
in handy when you start labelling your tool shop for the first time
or have to renew labels. There are two ways to do this:
- Per product: from the product overview, click the
When the product is non-serialized you get just one barcode
label. When it is a serialized product however a sub-menu
appears that allow you to print only the product code or the
selected serial numbers.
- Per storage location: Select Manage>Items per storage
This will show you an overview of all the tools per storage
location regardless of its current assignments. Select a storage
location in the right panel then select the tools you want print
barcode labels for in the left panel. Click the [Barcode]
button; if more than one tool is selected you get a warning that
you will print the selected number of labels. When you click
[OK] the labels will be printed.