I have managed to install this along with the server-side bits but am
having trouble getting the client and server elements talking to each
other.

I've had a look at the relevant document on MSDN and in the trouble
shooting guide it tell you to make sure that the MSSQLSERVER service is
not being run as the local admin and I've changed that but now when I run
my project it starts the automation manager (it's there on the task bar,
see it?) but I get this in the application event viewer...

CreateDispatch failed ( Access is denied.
 ). Check to make sure Automation manager is running on de{*filter*} machine.

The user I've created for the MSSQLSERVER service is can log on as a
service and is part of the admin group. Is there anything else I need to
do to make this work.

All advice and offers of help will be gratefully accepted.
-------------------------------------------------------------------
These are *my* opinions. Please don't make the mistake of believing
anybody else is stupid enough to think like this!
-------------------------------------------------------------------


 11 Glaisdale Dr East, Bilborough   | Tel: + 44 (0) 115 971 2000
 Nottingham NG8 4BU UK              | Fax: + 44 (0) 115 929 4668
-------------------------------------------------------------------