How to Fix Sage 50 Error Connecting to Database
In today’s competitive time, Sage 50 is touted as one of the best payment solutions available. But all good things aren’t easy to use and so is Sage 50. Unfortunately, sometimes, when you install the Sage 50 application on your computer, you might not be able to connect to the database due to some kind of technical error. So what you should normally do in such a case? Worry? Fret? Give up your hope? Nope! Just relax, don’t get dishearten and give all your worries to accountingadvice.co. Thinking how we can help? So, below more than five methods to troubleshoot Sage 50 database connection error. The best part is, the below mentioned solutions are absolutely easy to understand and implement, which you can follow on your own. However, before you start following the steps, make sure to update your Connection Manager on your PC. Once, you have checked and still you are getting Sage 50 database connection error.
Issue Resolution: Sage 50 cannot connect to database
Solution 1: If the data files are stored on your server computer, do the following
- First, test with the sample company.
- For Windows XP go to C:\Documents and Settings\All Users\Documents\Simply Accounting\201X\Samdata\
- And for Windows 7, Windows Vista and Windows 8 go to C:\Users\Public\Public Documents\Simply Accounting\201X\Samdata\
- In case, the sample company opens fine then we recommend you to do the following steps.
- Ensure that the firewall on your server where the data is hosted is configured appropriately (Note: It is important to note that the ports that are responsible for the communitarian with the Connection Manager are added).
- Find out whether your company data is saved on a server and what drive. Chances are you might have programs installed on the C: drive and data is stored on D drive. Check permissions of the shared folder where the data is located.
- On the root of C:\, make a new share folder.
- Now move the data in the new folder.
- Ensure that you give full permissions to all the users.
- Now try to open data from recently made new folder.
- Use data file with server’s IP address rather than the computer name.
- Check if the sample company opens or not
- Check the firewall or antivirus for blocked Sage 50 processes, in case there is any then give them the full access.
- For Windows XP users, in case antivirus/firewall has been adequately configured, and the sample company is still not working then the problem might be with the Microsoft .NET Framework.
- And if you are using Sage 50 on Windows Vista, Windows 7 or Windows 8-based compute and there is some problem in local sample company then the might be .NET components on your operating system might have been corrupted/damaged.
Solution 2: If the data files are stored in C:\PROGRAM FILES\ (or C:\PROGRAM FILES (x86)\) and the sample company file opens, follow the given below steps:
- Change the location of the .SAJ folder and .SAI file. Move them outside the C:\Program Files\ (or C:\Program Files (x86)\).
- Once done, right-click on the SAJ
- Then select Properties.
- Ensure that both Hiddenas well as Read-only checkboxes are unchecked.
- If they are, go to Security
- Ensure that all Groups or Usernamesmentioned have Full Control access rights.
- Select OK.
- Then open the SAJ folder.
- Find out and then remove the file pid.
- Ensure that you can now easily open the data file.
Solution 3: Check ODBC Issue
- Go to Programs and Featuresor Add Remove Programs on the control panel and make sure that ODBC is installed (If it is no installed, then install the ODBC by going to C:\Sage\Sage 50 Accounting <version>\BIN\MySQLODBC\).
- Now run the mysql-connector-odbc-commercial-<version>.exe
Solution 4: If your computer is new, bring it back to its default factory settings
- We recommend you to use the computer’s manufacturer restore disk and restore Windows Vista, Windows 7 or Windows 8 back to its default factory settings.
- Also, you can go through the manufacturer information
Solution 5: If the computer is not brand new, restore point
- We recommend you to use Windows Vista, Windows 7 or Windows 8 restore points to restore your computer to its previous settings when your Sage 50 application was working.
- To locate restore points, go to Windows Start, select Control Panel and then go to Systemor Recovery
- Find the restore point where the .NET components were updated and for that follow the wizard.
Solution 6: Call accountingadvice.co
If everything fails, we suggest you to avail professional Sage 50 technical support to fix the problem. We at accountingadvice.co provide comprehensive technical assistance to diagnose and fix all kinds of Sage error and problems proficiently. To avail our wide-ranging technical help, dial our toll-free number 1800-961-4623. We are available round the clock.
Report Your Issue
(Didn't find what you were looking for! Report your issue and get customized help from our Sage experts.)