I know my way around a SBS (2011) but not SQL (2008 r2)
I only need to test connectivity from a workstation, someone else is going to come in and handle the configuration.
I've found this post http://microsoftplatform.blogspot.co.uk/2010/12/test-remote-sql-connection-very-quickly.html
which seems to do what I require. I run this on the server and I can see the databases fine.
I run it on the workstation and it only shows me the server name and if I hit the test connection I get
Test connection failed because of an error in initialization provider - Server does not exist or access denied.
I've opened ports 135, 1433, 1434, 2383 & 4022 & ran Cliconfg.exe on both server & workstation and moved TCP/IP to the top of the list.
Now it's time to hand this issue over to some experts before I break something!
Probably the server is denying remote TCP/IP connections. That is, I think, the default setting in recent versions.