모 Network database on MS SQL Server - all your information in one database
The "MS SQL Server Support" function allows storing all information about orders, clients, and invoices in a single database. This means that data is organized, accessible to all employees, and consistent. Managers can be assigned different access levels so that each sees only the sections they need — orders, dealers, warehouses.
Additionally, MS SQL Server's power and user consolidation in a single database enable the use of advanced basic and additional functions.
In the basic version with a network database, it becomes possible to:
collect and analyze data for calculating manager salaries
Track workshop employee work, view reports on them.
Detailed order thumbnails on the "order information" tab
It becomes possible to use additional functions:
Video about the function: YouTube
Video about how to set up a company computer network: YouTube
It's also possible to have multiple network databases and connect to different ones as needed.
Connecting to SQL Server
Open settings→ Database In "Database Path" replace MS Access or select MS SQL Server by clicking the arrow A window will appear where you need to enter the server address, database name, SQL user login and password, then click "OK" If you encounter difficulties at this stage, read the article to the end and contact technical support.
Frequently Asked Questions
Failed to connect to the main database server
First, try restarting both the server computer and the remote computer!
This error can be caused by:
Software settings error - continue working in the local database, go to settings→databases→select SQL database→ in the window that appears, enter connection settings: server address, database name, login and password.
Firewall is blocking the connection. Create an allowing rule on both computers for port 1433.
Change in network path to server - ensure that computers are on the same local network (connected to the same router), or access is configured between networks.
ensure that the server's IP address remains the same and is accessible on the network
Example: you took a laptop with the program home, but there's no direct access to the office local network from home, and EasyCeiling cannot connect to the database.
Example: laptop was connected to the router via cable, but for some reason the connection was lost (cable was disturbed). Laptop connected via wi-fi, was assigned a different IP address, and the server at the previous address became inaccessible.
Example: you changed internet providers, or your provider installed new equipment for you. Since special settings (reserved IP address) were saved on the previous equipment (router, modem), and these settings are not present on the new one, connection to the SQL server with old data is not possible.
SQL server shutdown Ensure that: - the server computer is running - SQL server configuration has browser and server services running
SQL server settings change Ensure that: - in SQL server configuration→Protocols→TCP/IP→IPALL TCP port= 1433, dynamic ports are left empty - in server properties→connections the parameter "Allow remote connections" is set
firewall or antivirus is not blocking incoming connections
*for internet work model
Router settings change - ensure that port forwarding is configured to the server IP and the IP corresponds to the server.
Responsibilities of Parties
If MS SQL Server is used on the EasyCeiling server as part of the "Cloud DB Rental" service, then EasyCeiling company takes responsibility for database preservation and performance (within the tariff plan).
If MS SQL Server is used on the client's server, then the client independently bears responsibility for equipment and data preservation. When using own equipment, it's recommended to use the "Backup Wizard" function and perform work under the "Database Maintenance" service at least once every six months.
What questions does this article answer?
How to set up a centralized database for EasyCeiling?
What are the benefits of using MS SQL Server with EasyCeiling?
How to configure network database connection in EasyCeiling?
What additional features become available with network database?
How to troubleshoot SQL Server connection issues?
What are the responsibilities for database maintenance?
How to ensure data security in a network environment?
What are the best practices for database backup?
How to manage user access levels in EasyCeiling?
What are the system requirements for network database implementation?