Frequently Asked
Questions
Find Solutions to Common Issues Related to troubleshoot - sql connectivity
How to solved unable to connect SQL Server?
There could be several reasons you get these error messages. Follow the below steps to see if you can resolve the issue.
Step 1: Make sure you are able to ping the physical server where SQL Server is installed from the client machine. If this does not work, you can try to connect to the SQL Server using just the IP Address (for the default instance) or the IP Address\Instance Name for a named instance.
Step 2: Check that the SQL Services are running: Make sure the SQL services are running. You can check the SQL Server services by using the SC command opening SQL Server Configuration Manager. Many times you may find that the SQL Server instance is not running.
Step 3: Check that you are using the correct SQL Server instance name and Check that you can find the SQL Server.
Step 4: Check the TCP/IP and Named Pipes protocols and port. Open SQL Server Configuration Manager and check the SQL Server Network Configuration protocols. You should enable Named Pipes and TCP/IP protocol.
Step 5: Check that the firewall is not blocking access to SQL Server
Step 6:If required you can Install SQL Server with New Instance.
RTE-5 while creating company in SQL how to create company and resolved error?
RTE-5 while creating company in SQL to create company because of one of you company from your list is on offline, suspect or in recovery mode in SQL server management studio to fix this you 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. also if company show in recovery mode then you need to detached data and again attached.
10.after resolved all the issue restart SQL server manager and check in BUSY.
How do I troubleshoot server connectivity issues?
If you are facing issue to connecting client system with server system, you can try these troubleshooting steps:
Step 1: Make sure both systems are connected to the same network through LAN or WiFi.
Step 2: Configure the same data directory on the client system as the one set on the server system.
Step 3: Check the ping time of the server IP on the client system by typing “ping (IP Address) -t” in the run command. It should be 1 ms.
Step 4: Check if you can access the data folder under the network tab.
Step 5: Check if there is any firewall or antivirus software that might be blocking the connection.
Step 6: Restart BUSY on both systems and try again.
Step 7: If you are using SQL Database, make sure you have configured the Dongle server correctly.
Step 8: If you are connecting from different locations, make sure the required port is open on the internet router.
Further you can also contact us on our 24X7 helpline number: 8282828282 or 011 40964096. You can also email us your query at support@busy.in.
client show in demo mode and data not shwowing in list how to resolved this issue ?
Client system is running in demo mode to fix this there is two way
A. if you are using data on access mode and client system is running in demo mode to fix this follow these steps
1.Close BUSY on the client system.
2.Go to the network option.
3.Select the server system.
4.Give full access permission to data from properties.
5.Copy the data path from networking.
6.select the data path in BUSY data directory.
7. open list of company.
8.If still in demo mode, check internet or LAN connectivity.
B. If using data on SQL mode, follow these steps:
1.Ensure server information is correct.
2.Confirm BUSY agent is running and added to the startup bar.
3.Ensure dongle server configuration is enabled.
4.VeriFinancial Year same internet connectivity for server and client.
5.Enable SQL TCP port 1433 in SQL server manager and add to firewall inbound rules.
6.Set user control settings to never notiFinancial Year in Windows.
7.Mention correct server information in the client system.
8.Close and reopen BUSY.
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
