Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
If you are running SQL server express then you need to enable the TCPIP protocol. If you have a firewall running then you need to open port 1433 for SQL server.
You don't have to open port 1433 if the firewall is off. Double check your work, either the SQL server name is incorrect or the firewall is running and port 1433 is not open.