Frequently Asked
Questions
Find Solutions to Common Issues Related to troubleshoot - sql connectivity
How do I open port for BUSY?
To open port 443 for BUSY, you need to go to
Step 1 : The Control Panel
Step 2 : Then to the Windows Defender Firewall
Step 3 : And create a new inbound and outbound rule for the port.
Step 4: Make sure to enable the port for both Inboard and Outboard roles.
How can i change the SQL password as it appears incorrect while conect BUSY in sql edition?
To change the SQL password, follow the below steps:
Step 1: Open Microsoft SQL Server Management Studio.
Step 2: Login the SSMS with window authentication option.
Step 3: Click on security then select the login tab
Step 4: Now, select the SA user and speciFinancial Year password as per choice and save the configuration.
In client system data is not showing in BUSY,as party use SQL database.
If data is not showing in client system in SQL database ,you may follow given steps:
Step: 1 Check Server info of client system.
Step: 2 In case of LAN Check by ping LAN ip in client system.
Step: 3 Create inbound and outbound rule with port code 1433 in system firewall.
How to configure the Folder permissions?
To provide full permissions or full control to the BUSYWIN folder, follow these steps:
1. Locate the BUSYWIN Folder
2. Right-click on the BUSYWIN folder.
3. From the context menu, select Properties.
4. Go to the Security Tab
5. Edit Permissions
6. Add a User or Group
7. Set Permissions
8. Apply Changes
9. Confirm Changes
10. Close Properties
What is a static IP address and how can it be used for client-server distribution in BUSY Accounting software?
A static IP address is a fixed internet address that remains the same and can be used to connect a client system to a server when both system are connected to different network . It is required for client-server distribution and can be purchased from an IT person.
What troubleshooting can you recommend when show sql sever does not exist/access denied
If show sql server error check these steps:
1. Check Set server information
2. Check sql management studion is open or not with this credential detail
3. Create inbound and outbound rule and restart sql service
4. Check tcp ip is enable or not in ipv4 or ipv all
While clicking on open company menu showing sql user name and password wrong.
To change your sql password follow below steps:
Step 1: Login into SQL Server using Windows Authentication.
Step 2: In Object Explorer, open Security folder, open Logins folder. Right click on SA account and go to Properties.
Step 3: Change SA password, and confirm it. Click OK.
How can i tackle the error for sql installation for same instance name while installing sql?
If you are installing SQL with default instance and the sql has already been installed in the system then it will popup an error for same sql instanace. In order to overcome this issue, you need to install sql with named instance option.
What is SQL installation and how can it help with BUSY performance issues?
SQL installation is the process of installing SQL server software on a server or main system. It can help with BUSY performance issues by allowing data to be stored and accessed more efficiently, which can improve the speed and reliability of the software.
When I try to sync data, I get an error that says "Error found during synchronization. SQL server connection read. You can not proceed." How can I fix this?
try to sync data, get an error that says "Error found during synchronization. SQL server connection read. You can not proceed.
so for that you need to check network connectivity between HO and BO, also check TCP port 1433 was open or not