Frequently Asked
Questions
Find Solutions to Common Issues Related to troubleshoot - sql connectivity
LAN System not connecting with server system
If Your LAN or Client system not connecting with server then follow
the steps
1 Go To server System and click on internet and sharing centre from
control panel and set Your LAN IP first
2 Then Go to SQL configure manager option and open sql server network
configuration enable TCP option and set the lan IP and port and save it
3 Restart the browser in sql server configure manager
4 Allow 1433 port from firewall through inbound outbound rules and allow
BUSY app and BUSYwin folder from antivirus
5 share the folder with everyone where the licence file folder exist
6 restart computer and refresh dongle server or refresh BUSY agent
7 open BUSY in client system and set server information and restart BUSY
How to add costing column in sales register?
To add the item cost price in the sales register, follow these steps:
To calculate the sale value on a cost basis in the sales register, follow these steps:
Method 1
1. View the report under Display
2. MIS reports
3. Profitability reports
4. Bill-wise
5. Select the required Item Cost price like Weighted average,Last purchase, Last sale etc
6. Next view the report
Method 2
1. Or you can Go to Display: Inventory Books: Inventory Register: Sales Register.
2. Select the required filter from the list.
3. Click on the Custom Columns options to add a new column.
4. Add the format.
5. Add a new column.
6. SpeciFinancial Year the heading, datatype, alignment, etc.
7. Select the datafield Inventory voucher (Body).
7. Add ITEM_COST_AMOUNT and save.
8. Reload the report and select the format name to view the report.
How to install SQL server please guide the process
To install sql server you need to Follow the steps
before installing sql server you need to ensure your sql version is compatible
with windows version
1 Go to the sql configure manager exe file and enter then click on new installation
2 then let the installation and after it click on yes
3 on license terms option enable I accept then click next
4 select the required instanase features then click on next
5 on instance configuration option click on default instance and click next
6 On server configuration option make sql server browser automatic and click next
7 on database engine configuration tick on mixed mode and enter a password and
confirm password and next
8 then let the installation process complete and finish
What to do while Creating Co. ETR5 showing?
To convert SQL 2019 data into SQL 2017, follow these steps:
Step 1: You have to make sure both SQL 2017 and SQL 2019 have both SQL versions installed.
Step 2: After the above confirmation, you should create a BUSY ICON with BUSY SQL 2017 server information.
Step 3: After this, you need to create a company in the SQL 2017 version and Go to Administration.
Step 4:then select Data Export Import, then select Import Data from SQL, then select the server information from SQL 2019.
Step 5: Click on the right arrow and select the company from which you want to import data and speciFinancial Year the user and password, then click on the import tab to import the data.
unable to install SQL configure manager
To use sql configure manager you have to follow the steps but sql installation based
on windows version
1 Go to the sql configure manager exe file and enter then click on new installation
2 then let the installation and after it click on yes
3 on license terms option enable I accept then click next
4 select the required instanase features then click on next
5 on instance configuration option click on default instance and click next
6 On server configuration option make sql server browser automatic and click next
7 on database engine configuration tick on mixed mode and enter a password and
confirm password and next
8 then let the installation process complete and finish
Encountering an error SQL Server does not exist. How can I Troubleshootthis problem during installation?
To Troubleshootthe SQL Server does not exist error during installation, follow these steps:
1. Confirm SQL Server installation on the intended server.
2. VeriFinancial Year the correct server name and ensure reachability.
3. Check network connectivity and firewall settings.
4. Confirm the SQL Server service is running.
5. Ensure the SQL Server Browser service is active for named instances.
6. VeriFinancial Year SQL Server allows Authentication and set the appropriate mode.
7. Examine SQL Server error logs for insights.
8. Check firewall settings to allow incoming connections.
9. Try connecting using the IP address instead of the server name.
10. Consider repairing the SQL Server installation for any corruption.
11. If issues persist, consult system administrators or IT support for assistance.
RTE 5 randomly on server, what to do?
It happens in multiple cases. Please elaborate on query one of the following solutions in the case of SQL.
To resolve the issue of opening a company in SQL mode for RTE 5, follow these simple steps:
Step 1: Open SQL Server Management Studio (SSMS) and connect to your SQL Server.
Step 2: If you see a Recovery Pending label or the expand symbol is not visible in a BUSY database, do the following:
a) Right-click on the database.
b) Go to Task.
c) Select Take Offline.
d) Now, click on Bring Online from the same menu.
Step 3: If the database shows a suspect label, you need to run a query to remove the suspect status.
How to install SQL, and after that, how to attach the data with SQL?
After SQL Management studio, you can attach the files as per the below-given steps: Steps
1. Open SQL Management Studio.
2. Connect to the SQL Server instance by clicking the Connect button.
3. In the Object Explorer, locate and right-click on the Databases node.
4. From the context menu, choose Attach
5. In the Attach Databases window, click the Add button to browse and select the database files you want to attach.
6. Once you have selected the files, click OK
7. Review the details in the Attach Databases window, ensuring the correct files are listed.
8. Click OK to complete the attachment process.
Now, the specified database files will be attached to the SQL Server instance.
While Opening Company In SQl it is showing SQL SA user is Lock, How to fix it.?
To unlock the SQL SA user and resolve the lockout issues, follow these steps:
Step 1 : Open SQL Server Management Studio (SSMS) as an administrator.
Step 2 : Log in to SQL Server using Windows Authentication.
Step 3 : In SSMS, find and expand the Security section under SQL Server, then select Logins.
Step 4 : Now Expand the logins, right-click on the SA user, and choose Properties.
Step 5 : Under the Status option, find 'Login is lockout' and uncheck this option.
Step 6 : Go to the General section, and reset the password for the SA user.
Following these steps should unlock the SQL SA user and resolve any lockout 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
