Failed to Create Landlord Database Tables for Sage 300
Summary
While configuring the portal database in database setup for Web Screens, after entering the SQL login and password and pressing OK, user receives the following message: “Error: Failed to create landlord database tables”
Cause
The error occurs when the TCP/IP protocol is not properly set up in SQL Network configuration of the SQL Server.
In SQL Express, the default TCP/IP connections settings are disabled.
Resolution
- Launch the SQL Server Configuration Manager
- Under the SQL Server Network Configuration tree, click Protocols For [SQL instance name].
- Enable the TCP/IP protocol. (The default setting is Disabled)
- Right-click the TCP/IP protocol, and then click Properties
- On the IP Addresses tab, in the IP All Section: Clear the TCP Dynamic Port field
- Set the TCP Port to 1433
- Restart the SQL Server Service.