In the new version of Sage 300, we have been introduced to the web screens. Sage 300 ERP will now be called as Sage 300c ERP which now will be used on cloud that will make it easier to access from the web. As this is a newly introduced concept, there are chances that we might face errors during the configuration stage. In this blog we will check how to troubleshoot the most common error that may occur during the configuration of the Web UIs.
Mostly after installation of the Web Screens, it is necessary to configure the ‘PORTAL’ in the database setup screen. But when user tries to configure the PORTAL in the database setup they might come across the error : “Error. Failed to create landlord database tables”
Please refer the below screen shot.
Below are few points that can be followed to overcome the error:
1. Verify “PORTAL” Database ID on SQL server:
Before proceeding to verify other points, please make sure you have created the PORTAL database. This PORTAL database later needs to be specified in the database setup during the configuration of the Web UIs. Hence, it is the basic step to look out for this error.
2. Check whether the SQL services are running on the server:
Once you have created the “PORTAL” database on SQL server, and still if you are facing the same error, ensure if the SQL services are in running status.
To do this, you can follow below steps:
a. Get access to your database server either by logging into to console or initiating a Remote Desktop Protocol (RDP) session to the server.
b. To check the services, enter ‘services.msc’ in RUN command and click on enter to open the Services Management as shown below :
The highlighted service should indicate that their status is ‘Running’ and Startup Type is set to ‘Automatic’.
c. You can start/re-start this service by right clicking on the SQL Server service and choosing ‘Start’ or ‘Restart’ as highlighted below.
If the SQL Server service is not shown as ‘Running’ you have more likely found the root of your problem! But still you can look out for below option if the error persists.
3. Verify whether the Port number for SQL server database engine is defined:
To assign a TCP/IP port number to the SQL Server Database Engine.
a. In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration, expand Protocols for <instance name>, and then double-click TCP/IP.
In the TCP/IP Properties dialog box, on the IP Addresses tab, several IP addresses appear in the format IP1, IP2, up to IPAll.
b. In the IPn Properties area box, in the TCP Port box, type the port number you want this IP address to listen on, and then click OK.
c. Restart the SQL Server and SQL browser services to take the effect.
Once you are done with the above steps try to reconfigure the Web UIs and it should connect without any problem.
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.
Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, Salesforce.com and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrix, Document Attachment, Document Numbering, Auto-Bank Reconciliation, Purchase Approval System, Three way PO matching, Bill of Lading and VAT for Middle East.
For more details on Sage 300 and 300c Services, please contact us at firstname.lastname@example.org. We will be glad to assist you.