Hey guys, thanks for all the responses.  Seem to have solved the issue now.

SBS by default adds two...

Thanks Jeff.  Currently the server name is simply – Server – and the string to access the datasource is server\fininv.  I have tried double and...

Thanks for that.  Access to the instance from the SBS server itself is fine.  Changing the name of the server to the IP address failed. Ping and Tracert to server...

Hi Jason - We're using ODBC and at the moment the firewall is switched off - both ports are open.

Cheers

Paul