Thank you for looking at my question,
Had a new server installed yesterday running MS SQL Server 2008 on SBS 2011.
Databases have been restored successfully - can see tables, views etc.
I tried to create on ODBC connection on the server and get:
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][DBNetLib]ConnectionOpen
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNetLib]SQL Server does not exist or access denied
I don't know where to start looking - please help