If you are using SQL Server 2005 and not able to connect to it remotely, then check out this useful blog post.