How do I send a MySQL database to AYS?
You must first export (or dump) the MySQL database from the database server before it can be sent to AYS. Here are two options for creating that file to send to us.
Editions : Repair Enterprise
Error -2147217900 [SQL Server]CREATE TABLE permission denied
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.
How to Configure MySQL for AYS
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.
How to Configure Microsoft SQL Server for AYS
Certain SQL Server permissions are necessary for AYS users to access the data and run reports. This article will assist you in configuring the security on recent versions of Microsoft SQL Server.
Which MySQL versions are supported?
At Your Service – Repair Center works with the following MySQL versions:
Which Microsoft SQL Server versions are supported?
At Your Service – Repair Center works with the following Microsoft SQL Server and SQL Server Express versions:
Is there a cloud version of AYS?
At Your Service – Repair Center is a traditional desktop application, but you can run it remotely on certain cloud services.
How to Configure Microsoft SQL Server Express for AYS
SQL Server Express can be used instead of larger deployments of SQL Server, depending on your company’s requirements.
Database configuration and setup described in this article can be followed, but by default, the server is not accessible over the network. Follow these steps to make the server visible so that you can connect to and configure the server from another workstation on the network.
Note
At Your Service Software, Inc. will not provide support for installing or administering SQL Server on your hardware and network. Please consult a local IT service provider and/or Microsoft for this service.
Online Solutions for Customers and Dealers
At Your Service Repair Centre can integrate into an online environment and allows you to provide high quality and efficient service to your customers and dealers.
AYS Repair Centre supports:
- Online Repair Order Entry
- Online Repair Status Lookup
- Repair Status Notification
- Scheduled Data Imports and Exports
How do I send a Microsoft SQL server database to AYS?
A Microsoft SQL server database backup (.BAK) file must be created using SQL Server Management Studio, and then that backup file can be sent to AYS.