Frequently Asked
Questions
Find Solutions to Common Issues Related to troubleshoot - sql connectivity
while open company in SQL database RTE showing?
to fix error while open company in sql follow these steps
1. open SQL server management studio
2. login with SQL authontication mode with correct user name and password .
3. then open databse file
4. check if company data file showing offline or suspect mode
5. if showing in offline mode then right click on file
6. click on task option
7. bring file offline and then again bring online then restart SQL server manager and check in BUSY .
8. also if comapny file showing in suspect mode then you need to run SQL query for that here give below the SQL query.
EXEC sp_resetstatus COMPINFO;
ALTER DATABASE COMPINFO SET EMERGENCY
DBCC CHECKDB (COMPINFO)
ALTER DATABASE COMPINFO SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CHECKDB (COMPINFO, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE COMPINFO SET MULTI_USER
note : replace COMPINFO WITH suspect file name(db or Financial Yearfile)
9.after run query restart SQL server manager and check in BUSY.
Timely fashion error (RTE-3146)in SQL & service is not getting started
To resolve Timely fashion error on SQL follow the below solutions
Solution-1 Disable name pipe from SQl server from SQL server configure manager select SQl server network configuration then click on the + sign to select Protocol for SQL and then select Named pipe right mouse click and click on disable option . if SQL is connect in IP then no need to enable named pipe , and then start the service from SQL server configuration manager then select SQL server service then select SQL server right mouse click and select start option.
Solution 2: Replace temp file on SQL data folder from program file folder under program file folder click on Microsoft sql server folder then click MSSQLSERVER then click MSSQL folder and then click template data ,then copy both file Master and Mastlog and then past in the DATA folder available under MSSQL folder.
Handling situations when there are no details on the BUSY server?
If you are using SQL database in BUSY and details showing on the server system, you can follow these steps to handle it:
Step 1: Check the server information is correctly mention and check when you click on Open Company there is not showing an error message of SQL Server Does Not Exist.
Step 2: If Server info is missing or incorrect the you can check it from SQL Management Studio and mention in BUSY.
Step 3: Also ensure that the SQL services is running.
Step 4: Make sure your antivirus or firewall not blocking the SQL services.
If you need any assistance you can reach out to us on our 24X7 helpline number: 8282828282 or 011 40964096. You can also email us your query at support@busy.in.
Issue in generating SF in BUSY?
To generate SF while BUSY, you need to follow the below steps:
Step 1: Go to the company menu before logging in to the company; in that, you will find the Set data directory or Set server information.
Step 2: In this window, you will find the option to generate a security file (SF). Click on it.
Step 3: Then you have to speciFinancial Year the company-accepted information in that you have to put COMP0001, COMP0002, ect.
Step 4: Select the data path file and click on generate data path file, or if you require a password for the data file, you can click on that option.
Step 5: After this configuration, your SF file will generate, and you can speciFinancial Year this on the Read server information from the security file.
Why does SQL Server not exist automatically after installation, and how to solve this?
Here are some steps to Troubleshootthe SQL Server does not exist issue:
1. Ensure that the SQL Server service is running.
2. VeriFinancial Year Server Name:
3. Check the firewall settings to ensure that SQL Server traffic is allowed.
4. Use the SQL Server Configuration Manager to check the network protocols enabled for your SQL Server instance. Ensure that TCP/IP and Named Pipes are enabled.
5. If you are using a named instance, make sure the SQL Server Browser service is running.
6. Ensure that you have entered correct server name, authentication method, and other necessary details.
7. VeriFinancial Year the SQL Server SA account login credentials.
8. Check the SQL Server error logs from Event Viewer The logs can provide detailed information about the problem.
9. Finally you can install SQL Server
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
