I have SQL 2008 Server Express installed on my machine But It was not discoverable in network and this was preventing me to access my sql server instance from another pc.
After goggling I came to know this was because “SQL Browser” service was not started in my machine. Once I started it, I was able to connect my SQL server instance from another machine.
Below is nice link which guide step by step on this issue.
1) http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/
2) http://kristofmattei.be/2009/10/25/sql-server-2008-express-edition-access-over-network/