Frequently Asked
Questions

Q: While opening client system showing sql server does not exist

If the client system not connecting with server system on sql mode then follow the steps 1 go to server system and set lan IP 2 open sql server configure manager and click on sql server network enable TCP and configure the local ip on TCP4 option and make the port code 1433 3 then restart the sql browser 4 share the advance sharing option from control panel 5 allow BUSY and 1433 port from windows firewall through inbound outbound rules 6 restart the server system and refresh dongle server 7 then open client system and set server information and restart BUSY on client system

Q: unable to split company at location C, what to do?

If you are unable to split company at location C, you need to follow the below steps: First, you need to check whether it is Access or SQL. Step 1: In the case of Access Data Base, you can split data companies. Before opening the company in BUSY, from the split company option, you need to select the company and then select the financial year for which you want to split, and it will split your financial year. Step: In the event that SQL data base SQL 2019 is not supported, make sure you install the SQL 2017 version to split the financial year.

Q: My Server system BUSY show demo mode in case of SQL Mode

Step 1: Must be check Model in BUSY software Step 2: Go to licence management > Revalidate softlock In case Hard Disk mismatch: Step 1: Go to Licence management Step 2: Go to Get softlock Licence Serial No Registered Email id Registration Password (Forgot Password) Step 3: Surrender Softlock Licence file (Ask Would you like to continue with Surrender ?) Serial No Registered Email id Registration Password (Forgot Password) Step 4: Softlock Registration Serial No Activation Key >Validate Serial No Register softlock Step 5: After Received Licence file on mail Step 6: download file > Copy licence file > Paste where is BUSY installed >Reopen BUSY

Q: How to configure SQL TCP port of 1433 or other

To configure TCP port in SQL configure manager you need to follow the steps 1 set your LAN IP first in your server system then go to windows home screen and search SQL server configure manager 2 open SQL server manager and click on sql server network configuration 3 Click on protocol for ms sql server 4 enable tcp and right click on it and click on properties 5 Click on IP address then go to IPV4 option and set the local IP address and make port 1433 or other which was enabled and save 6 then restart the brwser

Q: How can the issue of LAN connectivity for SQL to the server PC be resolved?

If you're facing LAN connecting issues for SQL connectivity to the server PC, consider the following steps: 1.Ensure the server information is correct & Provide the correct server information on the client system. 2.Open SQL Server manager & then check sql server network configuration then check TCP Ip is enabled. 3.VeriFinancial Year LAN connectivity for both the server and client through PING 4.Enable SQL TCP port 1433 in SQL Server Manager and add it to the firewall inbound rules. 5.Exclude TCP port 1433 from antivirus program 6.Set user control settings to Never NotiFinancial Year in Windows. 7.Close and reopen BUSY after completing the above steps.

Q: What is the difference between BUSY access and sql data base?

In BUSY, you can maintain both access and SQL data base. Check the basic difference between both database: 1.Access database is compatible for data till 2Gb size. If the data is heavy beyond 2Gb , it is recommened to run data on SQL data base. 2.Data speed will be enhance in sql database. 3.To run BUSY on 2 different location, you need to run BUSY on sql data base with required Static ip and port forwarding of SQL. 4.If you want to implement Head office and branch office in BUSY, then the head office must be run on SQL data base.

Q: While open SSMS databse showing data under recovery

If showing data under recovery in SSMS then follow the steps 1 Open SSMS and click on database folder 2 then open database folder and select the file which showing data under recovery and copy it 3 then right click on it and click on new query then paste the SQL suspect query file 4 and remove the compfile data name and paste the copied file which showing data under recovery 5 then click on execute and wait for the process 6 after completing the process save and close ssms it will be resolved

Q: I want to install SQL Server 2016. Can you provide guidance on the installation process?

To Install the SQL 2016 you can follow these steps 1. Obtain the SQL Server 2016 installation media from the official Microsoft website. 2. Run Setup 3. Choose Installation Type 4. Follow Installation Wizard 5. SpeciFinancial Year Instance Configuration 6. Define the instance name and instance features. 7. Configure Server Authentication 8. Choose the authentication mode: Mixed Mode. If Mixed Mode is selected, set a strong password for the 'sa' (System Administrator) account. 9. Select Features 10. Choose the SQL Server features you want to install. 11. SpeciFinancial Year Data Directories to install 12. Configure Server and Network 13. Install and Complete

Q: What could be the reason to connectthe SQL on client PC?

To connect the SQL on client pc, check the below possible aspects: 1.Dongle server must be open in server system in order to connect the client system. 2.Sql server information and password should be speciFinancial Year correctly in client system. 3.In sql server, check and setup the TCP/IP setting in SQL server manager. 4.Add SQL port to the inbound rules in window firewall advanced setting. 5.In case of lan connectivity, lan ip must be ping on client system and in case of different location, static ip must be ping on client system. 6.BUSY must be open in server system.

Q: what could the possible reason for not connecting client pc.

To connect the SQL on client pc, check the below possible aspects: 1.Dongle server must be open in server system in order to connect the client system. 2.Sql server information and password should be speciFinancial Year correctly in client system. 3.In sql server, check and setup the TCP/IP setting in SQL server manager. 4.Add SQL port to the inbound rules in window firewall advanced setting. 5.In case of lan connectivity, lan ip must be ping on client system and in case of different location, static ip must be ping on client system. 6.BUSY must be open in server system.

Find Solutions to Common Issues Related to troubleshoot - sql connectivity

Taxation (GST/VAT/TDS/TCS/RCM)

Export/Import/Data Conversion

Errors (RTE/Ransome), Feedbacks and Bugs

Barcode, QR Code and Lable Printing

License Management/Softlock/Hardlock

Enquiry/Upgrade/Visit/Renewal

UMS Related Issue (Dealer Query)

Software Features

Implementation

Dealer Complaint/Issues

Enquiry/Upgrade/Visit/Renewal

Dealer Complaint/Issues

While opening client system showing sql server does not exist

If the client system not connecting with server system on sql mode then 
follow the steps 
1 go to server system and set lan IP 
2 open sql server configure manager and click on sql server network 
enable TCP and configure the local ip on TCP4 option and make the port code 1433 
3 then restart the sql browser 
4 share the advance sharing option from control panel 
5 allow BUSY and 1433 port from windows firewall through inbound outbound rules 
6 restart the server system and refresh dongle server 
7 then open client system and set server information and restart BUSY on client system

unable to split company at location C, what to do?

If you are unable to split company at location C, you need to follow the below steps:
First, you need to check whether it is Access or SQL.
Step 1: In the case of Access Data Base, you can split data companies. Before opening the company in BUSY, from the split company option, you need to select the company and then select the financial year for which you want to split, and it will split your financial year.
Step: In the event that SQL data base SQL 2019 is not supported, make sure you install the SQL 2017 version to split the financial year.

My Server system BUSY show demo mode in case of SQL Mode

Step 1: Must be check Model in BUSY software
Step 2: Go to licence management > Revalidate softlock
 In case Hard Disk mismatch:
Step 1: Go to Licence management
Step 2: Go to Get softlock Licence 
Serial No
Registered Email id 
Registration Password (Forgot Password) 
Step 3: Surrender Softlock Licence file (Ask Would you like to continue with Surrender ?)
Serial No
Registered Email id 
Registration Password (Forgot Password) 
 Step 4: Softlock Registration 
Serial No
Activation Key >Validate Serial No
Register softlock 
Step 5: After Received Licence file on mail 
Step 6: download file > Copy licence file > Paste where is BUSY installed >Reopen BUSY

How to configure SQL TCP port of 1433 or other

To configure TCP port in SQL configure manager you need to follow the steps 
1 set your LAN IP first in your server system then go to windows home screen and 
search SQL server configure manager 
2 open SQL server manager and click on sql server network configuration 
3 Click on protocol for ms sql server 
4 enable tcp and right click on it and click on properties 
5 Click on IP address then go to IPV4 option and set the local IP address and make 
port 1433 or other which was enabled and save 
6 then restart the brwser

How can the issue of LAN connectivity for SQL to the server PC be resolved?

If you're facing LAN connecting issues for SQL connectivity to the server PC, consider the following steps:
1.Ensure the server information is correct & Provide the correct server information on the client system.
2.Open SQL Server manager & then check sql server network configuration then check TCP Ip is enabled.
3.VeriFinancial Year LAN connectivity for both the server and client through PING
4.Enable SQL TCP port 1433 in SQL Server Manager and add it to the firewall inbound rules.
5.Exclude TCP port 1433 from antivirus program
6.Set user control settings to Never NotiFinancial Year in Windows.
7.Close and reopen BUSY after completing the above steps.

What is the difference between BUSY access and sql data base?

In BUSY, you can maintain both access and SQL data base. Check the basic difference between both database:
1.Access database is compatible for data till 2Gb size. If the data is heavy beyond 2Gb , it is recommened to run data on SQL data base.
2.Data speed will be enhance in sql database.
3.To run BUSY on 2 different location, you need to run BUSY on sql data base with required Static ip and port forwarding of SQL.
4.If you want to implement Head office and branch office in BUSY, then the head office must be run on SQL data base.

While open SSMS databse showing data under recovery

If showing data under recovery in SSMS then follow the steps 
1 Open SSMS and click on database folder 
2 then open database folder and select the file which showing data under recovery and 
copy it 
3 then right click on it and click on new query then paste the SQL suspect query file 
4 and remove the compfile data name and paste the copied file which showing data under 
recovery 
5 then click on execute and wait for the process 
6 after completing the process save and close ssms it will be resolved

I want to install SQL Server 2016. Can you provide guidance on the installation process?

To Install the SQL 2016 you can follow these steps 1. Obtain the SQL Server 2016 installation media from the official Microsoft website.
2. Run Setup 
3. Choose Installation Type
4. Follow Installation Wizard
5. SpeciFinancial Year Instance Configuration
6. Define the instance name and instance features. 
7. Configure Server Authentication
8. Choose the authentication mode: Mixed Mode. If Mixed Mode is selected, set a strong password for the 'sa' (System Administrator) account.
9. Select Features
10. Choose the SQL Server features you want to install. 
11. SpeciFinancial Year Data Directories to install
12. Configure Server and Network
13. Install and Complete

What could be the reason to connectthe SQL on client PC?

To connect the SQL on client pc, check the below possible aspects:
1.Dongle server must be open in server system in order to connect the client system.
2.Sql server information and password should be speciFinancial Year correctly in client system.
3.In sql server, check and setup the TCP/IP setting in SQL server manager.
4.Add SQL port to the inbound rules in window firewall advanced setting.
5.In case of lan connectivity, lan ip must be ping on client system and in case of different location, static ip must be ping on client system.
6.BUSY must be open in server system.

what could the possible reason for not connecting client pc.

To connect the SQL on client pc, check the below possible aspects:
1.Dongle server must be open in server system in order to connect the client system.
2.Sql server information and password should be speciFinancial Year correctly in client system.
3.In sql server, check and setup the TCP/IP setting in SQL server manager.
4.Add SQL port to the inbound rules in window firewall advanced setting.
5.In case of lan connectivity, lan ip must be ping on client system and in case of different location, static ip must be ping on client system.
6.BUSY must be open in server system.

Frequently AskedQuestions