Check
1. Whether th SQL server can accept remote connection ?
In your SQL server management studio right click on the database and select "properties" and the click on "connection" in the left hand side and make you the check box "Allow remote conenctions to this servers" is ticked
2. Whether you can ping ?
ping SERVER
in the command prompt
3. Whether your instance name is correct ?
4. Whether the ports are opened on the firewalls to connect the SQL server
http://support.microsoft.com/kb/287932[
^]