Articles

Enabling TLS to resolve “Unable to login to database server”

TLS 1.0 is a protocol used to provide privacy and data integrity between two communicating computer applications. The following “Unable to login to database server” message could occur if TLS 1.0 is disabled. In order to check to see if

Posted in Database

Delete Warehouse from a Product

Occasionally, you may want to remove a warehouse on a product.  This does not remove any historical transactions, or delete the warehouse from the database.  Removing the warehouse from a product hides the warehouse only for the product you are

Posted in Database, Inventory, Reports

Product Class: Product Class is ambiguous

As your business grows and you have the need for more and more product classes, the list can grow to a point that you may have accidentally created a duplicate Product Class.  The database must have a unique identifier to

Posted in Configuration, Database, Excel, Getting Started, Import Data, Inventory

“Operating System error system may not find the file specified e:\sql10_main_t….” when attempting to start the SQL Server service

A new installation of SQL Server 2014 express may present problems when starting the service at the end of the installation. You can attempt to start the instance by hand using “Service.msc”, browsing down to SQL SERVER (ACCTIVATE), right clicking

Posted in Database, Other Applications, Technology

Deleting Customers from Acctivate

You have old, inactive or duplicate customer records, now you want to delete them.  Acctivate does not allow users to delete customers once a record has been created.  While it may sound like a simple click of the mouse or

Posted in Customer, Database, Other Applications, QuickBooks and Sync

Migrating data from one Acctivate company file to another company file

For some users with multiple Acctivate Companies, there may come a time when you would like to migrate the data in one of the companies into the other. This can be due to a merger or a variety of other

Posted in Customer, Database

Stop Excel from Changing Numbers to Dates or Scientific Notations

We all know that Excel can be a powerful tool, however in an effort to anticipate the need of a user, Excel can also make it difficult to create spreadsheets for importing data into Acctivate.  You may have entered a

Posted in Database, Import Data

Acctivate Database Backup Prompt

In newer versions of Acctivate, there is a prompt upon exiting the application to create a backup if a SQL backup has not been run in the last 7 days. This prompt will show for all users until the backup

Posted in Database, Technology

Restore Acctivate Database in SQL Server Management Studio

If you are unable to restore your database file in AcctivateDBMaint or you are wanting to restore it to a different location than where Acctivate is installed then you may want to use SQL Server Management Studio to restore it.

Posted in Database

“Cannot Open Databases for Company…” on CYMA workstation

Cannot open databases for company _________. This error comes from the configuration of PSQL in the Acctivate sources. First you need to know if you are using a PSQL Server license or a PSQL Workgroup license to run CYMA with.

Posted in Database
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.