Frequently Asked
Questions

Q: I think there may be a problem with my SQL Server installation. What are some troubleshooting steps I can try?

There are several steps to troubleshoot SQL Server installation issues 1. make sure that SQL server version compatible with current windows version. 2. also verifying installation media or setup is correct or not 3.Ensure that the disk where SQL Server databases are stored has sufficient space and is healthy. Disk-related issues can impact database operations 4.Ensure that your SQL Server installation is up-to-date with the latest service packs and cumulative updates

Q: How can i reset SQL server password?

Resetting the password for SQL Server involves several steps: Step 1: Open SQL Server Management Studio Step 2: Connect to the SQL Server instance for which you want to reset the password Step 3: Under authentication option choose Windows Authentication mode and press on connect option Step 4: Then click on sercurity and expand it after that expand login option and right click on sa option and choose properties.

Q: Why is a particular company not appearing on the list, and what steps can be taken to resolve this issue?

When a particular company is not appearing on the list in an SQL database, you may encounter various issues. Here are steps to Troubleshootand resolve this problem 1. Ensure that SQL Information is correct 2. Check the database existance using SQL management studio. weather the data is suspect mode or data detached 3. Reindex the data externally from BUSY 4. Restart the SQL Service 5. Enable the database permission

Q: Why is BUSY not connecting after upgrading SQL server? How to fix sync issues after upgrade?

BUSY may not connect after upgrading SQL Server due to compatibility issues. To fix sync issues after an upgrade 1. There may be a compatibility issue. Please check the system configuration. 2. Download the correct installation files from the website. 3. Check firewall settings and disable the antivirus, then install. 4. Verify whether the 'C' drive is full. 5. Reinstall SQL once again. 6. Contact the BUSY Support team at 8282828282.

Q: What steps should I take before installing SQL

Before installing SQL, follow these steps 1 Temporarily disable antivirus and firewall. 2 Temporarily disable the firewall. 3 If using data in networking, set a fixed LAN IP. 4 Add the SQL port to the firewall. 5 Ensure that .NET Framework minimum version 3.5 is enabled. 6 Make sure you are logged into the system as an admin user. 7 Restart the system before initiating the SQL installation.

Q: What should I do if showing timely fashion error while start sql services?

If showing timely fashion error while start sql services then have to replace template file in Data folder of sql and check port in sql server configuration manager then restart sql services. Further if still issue persist then may be template data is corrupted and need to reinstall sql. Note: Take the latest backup of data before any process.

Q: How to resolve if unable to install SSMS?

If you are unable to install SSMS, you need to check the reasons below: 1. You need to make sure to enable the.net framework. 2. Make sure your SQL version and Windows version are compatible. 3. Run the set-up in administrator mode. Make sure you have logged in to your system in admin mode to install the set-up error-free.

Q: I am facing issue in sql data attachment how can i fix this?

If you are facing issue in SQL data attachment please ensure given below points: 1. Ensure that your data is not corrupted 2. All the required data files is available 3. If data is belongs to higher version then it will not attached in older sql version 4. Make sure you have the higher version of sql server

Q: What firewall settings should I use for BUSY?

To ensure proper functionality of BUSY, it is recommended to configure your firewall settings to allow inbound and outbound access for BUSY. Specifically, you should create a rule to open inbound port 1433, which is used by SQL Server for connectivity. This will help prevent any issues with accessing in BUSY and syncing data.

Q: Do I need to install any additional modules or software like SQL to maintain proper branching?

Find out the conditions in which you have to install sql to maintain Branch Step 1 : If your branch is in different location Step 2 : Then you have to install sql on your main head office server system Step 3 : And connect your branch company through ho/bo data sync feature

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

I think there may be a problem with my SQL Server installation. What are some troubleshooting steps I can try?

There are several steps to troubleshoot SQL Server installation issues
1. make sure that SQL server version compatible with current windows version.
2. also verifying installation media or setup is correct or not 
3.Ensure that the disk where SQL Server databases are stored has sufficient space and is healthy. Disk-related issues can impact database operations
4.Ensure that your SQL Server installation is up-to-date with the latest service packs and cumulative updates

How can i reset SQL server password?

Resetting the password for SQL Server involves several steps:
Step 1: Open SQL Server Management Studio
Step 2: Connect to the SQL Server instance for which you want to reset the password
Step 3: Under authentication option choose Windows Authentication mode and press on connect option 
Step 4: Then click on sercurity and expand it after that expand login option and right click on sa option and choose properties.

Why is a particular company not appearing on the list, and what steps can be taken to resolve this issue?

When a particular company is not appearing on the list in an SQL database, you may encounter various issues. Here are steps to Troubleshootand resolve this problem
1. Ensure that SQL Information is correct
2. Check the database existance using SQL management studio. weather the data is suspect mode or data detached
3. Reindex the data externally from BUSY
4. Restart the SQL Service
5. Enable the database permission

Why is BUSY not connecting after upgrading SQL server? How to fix sync issues after upgrade?

BUSY may not connect after upgrading SQL Server due to compatibility issues. To fix sync issues after an upgrade
1. There may be a compatibility issue. Please check the system configuration.
2. Download the correct installation files from the website.
3. Check firewall settings and disable the antivirus, then install.
4. Verify whether the 'C' drive is full.
5. Reinstall SQL once again.
6. Contact the BUSY Support team at 8282828282.

What steps should I take before installing SQL

Before installing SQL, follow these steps
1 Temporarily disable antivirus and firewall.
2 Temporarily disable the firewall.
3 If using data in networking, set a fixed LAN IP.
4 Add the SQL port to the firewall.
5 Ensure that .NET Framework minimum version 3.5 is enabled.
6 Make sure you are logged into the system as an admin user.
7 Restart the system before initiating the SQL installation.

What should I do if showing timely fashion error while start sql services?

If showing timely fashion error while start sql services then have to replace template file in Data folder of sql and check port in sql server configuration manager then restart sql services. Further if still issue persist then may be template data is corrupted and need to reinstall sql.
Note: Take the latest backup of data before any process.

How to resolve if unable to install SSMS?

If you are unable to install SSMS, you need to check the reasons below:
1. You need to make sure to enable the.net framework.
2. Make sure your SQL version and Windows version are compatible. 
3. Run the set-up in administrator mode. Make sure you have logged in to your system in admin mode to install the set-up error-free.

I am facing issue in sql data attachment how can i fix this?

If you are facing issue in SQL data attachment please ensure given below points:
1. Ensure that your data is not corrupted
2. All the required data files is available
3. If data is belongs to higher version then it will not attached in older sql version
4. Make sure you have the higher version of sql server

What firewall settings should I use for BUSY?

To ensure proper functionality of BUSY, it is recommended to configure your firewall settings to allow inbound and outbound access for BUSY. Specifically, you should create a rule to open inbound port 1433, which is used by SQL Server for connectivity. This will help prevent any issues with accessing in BUSY and syncing data.

Do I need to install any additional modules or software like SQL to maintain proper branching?

Find out the conditions in which you have to install sql to maintain Branch
 Step 1 : If your branch is in different location
 Step 2 : Then you have to install sql on your main head office server system
 Step 3 : And connect your branch company through ho/bo data sync feature

Frequently AskedQuestions