When setting up the Portal database in Sage ERP Accpac database setup, you may receive the following error:
"Invalid Input. Cannot connect to the server. You may have specified an incorrect server name or server port."
Enable the TCP/IP protocol in the network configuration window for the SQL server in the SQL Server configuration Manager window. The TCP/IP protocol might be disabled.
If you are using SQL server 'Express', confirm that under the TCP/IP protocol Properties, the TCP port is set to 1433. To do this, go into SQL Server Network configuration and then go to Protocols for the server. Right click TCP/IP, go to Properties and confirm that the TCP Port is set to 1433. The Default instance's port is 1433 unless you change it.
