RepairContact
1766A Union St
San Francisco, CA 94123
United States

Sage 300 Access Denied Error 49153

Technology

The error code 49153 is an Access denied error in Sage 300 which generally takes place while logging in to the Database. This majorly happens when using verify option in the Database setup for performing database connection testing. The error appears like “Cannot access database Error=49153″ may appear. The reason is the system failed to connect to the database in the newly installed system, client, or workstation. Let’s delve into the below article to know in detail the troubleshooting guide to resolve Sage 300 Access Denied Error 49153

Why did “Sage 300 Access Denied error code 49153” happen?

Here are the factors triggering the access denied error:

  • Unable to connect Sage 300 to the database
  • Network failures

How to resolve the Access denied error message 49153 in Sage 300?

Following are the methods to resolve the issue:

Fix the error on the client computer:

  • First of all open the Sage Database Setup
  • Click on the tab named Company
  • Hit the System Database Profiles button
  • Now check the server name and data source
  • Next, Make sure the database and Login ID names has been set
  • Now open the Control Panel, click Administrative tools, hit Data sources(ODBC)
  • It will open the ODBC data source Administrator
  • Next use the tab labeled System DSNs to discover the server name and data source name
  • After this confirm the SQL Server name in the DSN entry
  • Fill the User ID with the password in the SQL Authentication window
  • Now confirm the other remaining settings set as default
  • Next click on the DSN to test the database connectivity
  • Once successful then write the IP address in the DSN field
  • Now test again the connectivity of the database
  • If the connection failed then here are the steps you need to follow:
  • The user ID you are using failed to have permission to access the SQL Server
  • Now the SQL Server may not be ready to provide the connection

Fix the unable to access database error 40153 in a newly installed server:

Follow the jotted down pointers to connect the system to the database:

  • Open the service running in the SQL Server
  • Now set the TCPIP Static port in the SQL Server network configuration window
  • Set the service name protocols, IP Addresses option, TCPIP Properties, and the TCP Dynamic ports box to empty
  • Check you have configured the SQL Server instance to use the right port
  • The Firewall permits incoming traffic to the port named configured TCPIP
  • Verify-in the group policy in the router tab to check Security system is not blocking the service

Fix the error code” Cannot access database” when login to the existing computer:

  • Open the client computer
  • Now follow the below steps:
  • Open the Sage database setup
  • Click on the Company & system database profiles
  • The next thing is the check the server name or data source, database names, and login ID
  • Next, use the control panel to launch the ODBC Data Source Administrator
  • Now locate the System DNSs option
  • Discover the Data source name/Server name
  • Now after confirming the DNS entry in the SQL Server, enter the User ID & password in the Authentication window
  • Checks out the remaining settings are set as default
  • Run the database connectivity test from the DSN
  • Or use the Windows command prompt to ping the server name to verify address resolution & connectivity
  • Fill the IP Address
  • Check the User ID has been used and having rights to access the SQL Server

Conclusion

Here the article named “Sage 300 Access Denied Error 49153” came to an end! Hopefully, the write-up is beneficial for you. Now get connected to the Sage 300 expert’s team to know more or for in-depth resolution. You can use a live chat or send an email with your concerns to get exceptional assistance from the team. Taking a helping hand is a great time savior!

Frequently Asked Questions (FAQs)

How would I open the ODBC data source in my system?

Follow the link:

C:\Windows\SysWOW64\odbcad32.exe on 64-bit PCs.

What If the database connectivity failed while troubleshooting the error?

  • In such case, you can open the Window command Prompt
  • After that pings the server name
  • It will help you in testing address resolution & connectivity

Can I use the IP address to test the connection?

Yes you can directly use the IP address for testing the connectivity

Related Searches

Tags: , , , ,
No Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Learn-&-Fix-Quickbooks-Running-Error-Message (1)
QuickBooks Error
Learn & Fix Quickbooks Running Error Message

 QuickBooks running error message can be a symptom of many different underlying problems. To effectively troubleshoot the issue, you can reach out to our QuickBooks technical assistance team. Our team is available round the clock to assist you through such issues. QuickBooks Already Running QuickBooks Running error message is caused …

QuickBooks Crashes When Sending Email
Technology
QuickBooks Crashes When Sending Email

Are you tired of QuickBooks crashing every time you try to send an email? We understand how frustrating it can be, especially when you’re running a small business and need to quickly communicate with your clients. Fortunately, there are solutions to this problem that will save you time and headaches. …

Download QuickBooks Desktop 2023
Technology
QuickBooks Desktop 2023 – Download, New Features & System Requirements

Are you ready for the latest and greatest version of QuickBooks Desktop? Look no further than QuickBooks Desktop 2023! With new features and improved functionality, this accounting software will make managing your finances easier and more efficient than ever before. In this post, we’ll delve into the details of what’s …

Disclaimer - Repaircontact is the sole organization that provides you customer assistance for all the accounting services such as tax, payroll, accounting, inventory, customer transactions, bill payments, etc. All the content on the website is the property of the company and we are not associated with any third-party organization. We provide customer assistance 24/7 via a toll-free number, email, or live chat.