This is my job - I am retiring. The school moves to a new site next year, so there will be plenty to do and an opportunity to get in at the start of the new school identity.
Click Here for details
I've just had this issue when installing the client on a different subnet to the server. The SIMS installation writes a connect.ini with just the REDIRECT parameter in. I solved the problem by also including
ServerName=\SIMS2012
and for good measure
DatabaseName=SIMSwhatever
ServerType=SIMSSQL