Cannot Access Database Error 98 In Sage Accpac
Training Hosting Upgrades Extend Sage Magento eCommerce ADP Aloha POS Salesforce Other Solutions Industries Resources Blog Training Case Studies About Meet The Team Partners Careers Contact Home Resources Blog Sage 300: Unable to connect to database. Error = 98 Sage 300: Unable to connect to database. Error = 98 Blog Home Sage 300 CRM HRMS and Payroll Reporting Implementation Tweet Posted by EQ Tech on Thu, Sep 17, 2009 "Unable to connect to database. Error = 98" error message is received when user is attempting to open a company in Sage 300ERP (ACCPAC). This error may be caused by several reasons: The full domain name or IP address of a server may be entered in the DSN setup on the workstations.Go to Control Panel\Administrative Tools and select Data Sources (ODBC). This will open the ODBC Data Source Administrator window. Go to the System DNS tab. Check the configuration and be sure under the "Address" section of the Server area that the computer name of the server is entered. This may also occur if the Pervasive.SQL license is expired. Open the Pervasive Control Center from Start > Programs, go to "Utilities" >License Administrator. Enter the database server computer name, click connect, and verify the license key is "permanent" and has not expired. The server may not be set to accept remote requests. On the database server, open the Pervasive Control Center, select "Configure Local Engine", and under the "Access" section verify that the "Accept Remote Requests" option is turned on. Topics: Sage 300 (ACCPAC) All posts Submit a Comment Need Help Now? Products We Support Sage 300 Sage CRM Sage HRMS Sage FAS Sage Intelligence Sage Enterprise Intelligence Services We Offer Software Selection & Licensing Implementation Customization Support Training Hosting Upgrades Resources Blog Training Case Studies About Meet The Team Certifications & Partners Careers Contact San Diego Location Orange County Location Seattle Location Equation Technologies533 2nd Street Encinitas, CA 92024 Ph: 866.436.3530•E-mail: info@equationtech.us Equation Technologies ©2016 Contact Us | Privacy Policy
Forums Blogs Training Ideas Year-end center ACA Members More Cancel This group requires membership for participation - click to join Vanessa Ho 18 Jun 2014 ODBC Connections Microsoft SQL Sage 300 ERP database troubleshooting Related Content Connection terminated: Troubleshooting database errors One of the common issues that people may have encountered while using Sage 300 ERP are database errors. The majority of these issues is being unable to connect to the database. In this week’s blog post, we will highlight some of the common database errors and how to troubleshoot them. Before we start, please note that any troubleshooting steps noted require knowledge of database engines and application databases used by your Sage product (including Microsoft/Transact SQL, Pervasive https://www.equationtech.us/sage-accpac-blog/bid/25990/Issue-Unable-to-connect-to-database-Error-98 SQL, or MySQL, etc.). So if you are not knowledgeable in this area, please do not attempt to follow these steps on your own instead contact an authorized business partner or database administrator for assistance. We here at Customer Support are not responsible for assisting with these steps and cannot be responsible for errors resulting from changes to the database engine or databases. Finally, before making any changes, please make sure you’ve performed a full backup of https://sagecity.na.sage.com/support_communities/sage300_erp/b/sage_300_erp_supporthub/archive/2014/06/18/connection-terminated-troubleshooting-database-errors your database. Now that we got that out of the way, let’s take a look at some common database issues in Sage 300 ERP. The first one is Error 98 “Unable to connect to database”. You normally see this error when opening a Sage 300 ERP company or running Verify from Database Setup. It has been reported that this error occurs if you are using a Pervasive database (version 11) on a virtual server. It seems the cause is the Pervasive database became disabled due to a change in hardware configuration. To resolve this issue, all you need to do is re-install the Pervasive database and recreate the ODBC connection on the affected workstation. Another error you will see is Error 49153 where you cannot access the database during login. There are a couple of things that is possibly causing this error: You are not using System Administrator (SA) level SQL logon to create ODBC Data Source to connect to Sage 300 ERP databases located onMicrosoft SQL Server. Your firewall is blocking connection to the Microsoft SQL Server. To resolve this issue, you need to check to see if your ODBC data source can connect to your SQL Server. Follow these steps to see your ODBC connection. Identity the name of the data source used by the company database: From Windows, clickStart. In the Search box, typeDatabase Setup.
You are not logged in. [Log cannot access In] PlusCommunity.com - Where the ACCPAC® community meets! Register User Forum List cannot access database Calendar FAQ We cannot proceed. There was a problem looking up the post in our database. Please use your back button to return to the previous page. Privacy statement · My Cookies · Mark all read Powered by UBB.threads™ Contact Us · PlusCommunity.com - Where the ACCPAC® community meets! · Top