When updating At Your Service – Repair Centre to the latest version, you may come across the above error. This article will help you resolve the issue and upgrade your SQL Server database to the latest version.
Specific MySQL server permissions are necessary for AYS users to access the data and run reports. Some additional permissions may be necessary for those that administer the AYS database on the server. This article will assist you in configuring the security on MySQL for both of these cases.
At Your Service – Repair Center works with the following MySQL versions:
At Your Service – Repair Center works with the following Microsoft SQL Server and SQL Server Express versions:
The Retail SQL edition was renamed as the Retail Enterprise edition in June 2014 in preparation for the release of AYS version 4.0.
The Repair SQL edition was renamed as the Repair Enterprise edition in June 2014 in preparation for the release of AYS version 4.0.
While the physical databases are capable of storing millions of records, the practical maximum number of records that can be entered in the various database tables depends much on the type of database, the number of simultaneous users, and the physical server hardware.
Experience has shown that Microsoft Access databases with 5 to 10 users experience a gradual slowdown as more records are added with the practical limit being in the range of 50,000 to 100,000 records per table. Microsoft Access databases also have a physical file size limit of 2 Gigabytes.
SQL databases are much more robust and still perform responsively with millions of records.
Here are the requirements for setting up an At Your Service installation to connect to MySQL Server.