For Sage 100 2013 and higher
For Sage 100 (formerly Sage MAS 200 SQL) version 4.50:
If the error continues add a Firewall Inbound Rule for the SQL Server service:
Open port in Windows firewall for TCP Access
Open port in Windows firewall for UDP Access
Open access to SQL Server when using dynamic ports
If error continues, verify TCP/IP is enabled for Sage 100 SQL Server Instance
If you're using the Default SQL Server instance (MSSQLServer) and manually changed the PortID from 1433, use the steps below to resolve issue0