Skip to content

Sage ACCPAC Error 49153

Hey you! Yes, you!

All you have to do is type in your email address and you’ll hear from us. We respect your privacy and won’t do any funny business with your data.

Subscribe to our newsletter!

* By submitting your data, you agree to receive our weekly content newsletter called “What's Up Tech World?”. If you don’t like it anymore, you can unsubscribe any time.

Sage ACCPAC Error 49153

What is Sage ACCPAC Error 49153 & How to Fix It?

Sage is renowned accounting software with its dominating features and tools that have simplified business accounting. There are times when the user comes across some errors.

These errors can easily be resolved but there are certain instances where these errors can act as an obstacle in your work. One such technical error is Sage ACCPAC Error code 49153.

ACCPAC Error 49153

Sage ACCPAC Error 49153 means a user is unable to access the database. This error generally occurs in ERP applications. Sage ACCPAC is also known as Sage 300 ERP. When a user is trying to log in to their Sage ACCPAC application or trying to access a file related to it, they might encounter Sage ACCPAC Error code 49153. Sage 300 ACCPAC Error 49153 can be Solved by Checking if the Database Server is Operational.

Error Code
ACCPAC Error 49153Developer:
Sage Group
Error Description
“Cannot access database (error=49153)” Software:

Sage 50
Cause
The user has launched sage ACCPAC but failed in establishing a connection with the databaseApplies to:

Windows
SymptomApplication Failed in getting Connected with Database Possible Solution

Check that the SQL Server is working & then verify the SQL Server.  

To read more about Sage ACCPAC Error 49153 scroll below:

Exact Error Shown While User Facing Sage ACCPAC Error 49153

“Cannot access database (error=49153)”

The reasons behind Sage 300 Error 49153

Here are some possible reasons why it shows an error message on your PC screen:

sage-300-error-49153

Let’s see what they are:

  • Your database is probably offline
  • SQL database link is invalid
  • DNS server unable to migrate from one IP address to another
  • It may also be possible that Windows Firewall is stopping your Sage 300 software
  • The trouble with your version of database consumer
  • It displays you a frail server title.

It means the application failed in getting connected with a database. The user has launched sage ACCPAC but failed in establishing a connection with the database, thus resulting in an error. Also, when a user reports this error to the System administrator, the system admin will check whether a user can access SQL Database.

How to Fix Sage ACCPAC Error 49153

To solve Sage 300 ACCPAC Error 49153 first check that the SQL Server is working & then verify the SQL Server.  

Read More in detail below:

1. Solution One

Total Time: 9 minutes

  1. Step One

    Go to the start option and select the Run command.

  2. Step Two

    Type “Services.msc” and click on “OK”.

  3. Step Three

    Look for SQL server i.e. SQL Express.

  4. Step Four

    If the status shows that it is not started yet then start it manually.

  5. Step Five

    Click on “Start”, to start the process.

  6. Step Six

    As the Service control Pop up gets closed on its own, then the user can see in the following screen with status as Started.

  7. Step Seven

    Users will now have to log in to the Sage application, they can easily log into Sage ACCPAC.

2. Solution Two

  • Check firewall setting in your system.
  • Go to control panel and switch the firewall off.
  • If Sage application can get connected to database, then switch on firewall.
  • There is also an option called “Allow a program or feature through Windows Firewall” switch it on.
  • Select SQL server which is present in list or browse it and add it.

Here are two resolution methods by which Sage ACCPAC Error code 49153 can be resolved.

3. Solution Three

  • Inspect the Server
  • Start the Server, and type ‘services.msc’
  • The Services Management Window will appear
  • In the Right Hand Pane, Find the SQL Server (MSSQLSERVER)
  • When it Displays the status “Running” and the “Startup” type “Automatic”
  • If it does not display the Status, then that is the main issue
  • Restart the device by right clicking on the SQL Service or even one can restart from the drop down menu, to solve the Error
  • To Log In as Portion of Service, check the credentials, if the Server does not Start

4. Solution Four

  • Check If the Database Service is Operational
  • Check if the Server is Running, from the Server Console
  • Checking the database server by name, will tell if the server is up and running
  • The Database will also help you check if the server is visible on other computers on the network
  • To bring up the Command Box, Type ‘cmd’ and press Enter
  • At the C: Prompt type “Ping data base server” and Enter
  • If the message appears “The Ping Request Could not locate the host sql2016, please check and try again”, the server could be giving an issue
  • Restart the Database Server, by determining the state of the Server
  • Try to ping by IP Address, if it cannot be pinged by name

Alternate Methods to fix Sage 300 Error 49153


Method #1: Check SQL Server

To inspect SQL Server, users require to complete the command, and to do so Follow the below steps:

  • To start, hit the Windows Start button
  • After that type “services.msc” in the open search bar and press enter
  • After that, you require to confirm SQL Server (SQL Express)
  • If the status shows Shut Down you have to right-tap on the name and then hit “Start”
  • If you have initiated SQL Server then you can try to sign in to your Sage 300 Software.

Method #2: Fix open your Registry

If users are facing database-related problems then they require to modify the server route. This can smoothly be done by operating the registry. Here’s how:

  • First, from your console hit the Windows button + R keys to open the “Run” box.
    After this type “Regedit” in the search bar and then hit the Enter button
  • Now, find “HKEY_LOCAL_MACHINE-SOFTWARE\wow6432Node\ACCPAC International, Inc. \ACCPAC\”
    Next, update the route of the server to the sage 300 folders that you locate in Shared Programs and Data
  • When you are accomplished with this, run “SQL Server Configuration Manager”
  • And then if you want to see the subcategory option then tap on the Basic Client Configuration option
  • To detect TCP/IP, Named Pipes, Shared Memory you require to tap on “Client Protocol” or check if these options are enabled
  • Finally, go to “SQL Server Services” to start the services once again.

Also Read:



Disclaimer : We are a third party agency working on providing authentic support and full fledged services for for accounting software QuickBooks 2018 version. It is one of… Read more