OK so the issue here was actually in the SQL database. For some reason, even though the contents of this field seems OK we had to perform the following:
Open SQL server go to the database cssmaster and the table scheme.server
Right click and edit first 200 lines
The server name appeared OK allin capitals, but we went back to the app server and copied and pasted the name from 'system\computer name' and pasted it into the server_name column on the scheme.server table on the SQL server, even though the names appeared identical.
Once making this edit, the service started OK, as below:
sage1000.png You have insufficient rights to see the content.