Try this solution to do it manually:-
In order to connect to the Microsoft SQL Server 2005 remotely, TCP/IP needs to be enabled. This is disabled by default on Microsoft SQL Server 2005 Express edition. TCP/IP may also be manually disabled on other editions of Microsoft SQL Server 2005.
This article explains how to enable TCP/IP on Microsoft SQL Server 2005:
From the Microsoft SQL Server 2005 -> Configuration Tools, open the 'Microsoft SQL Server Configuration Manager'.
Expand ‘SQL Server 2005 Network Configuration’, and then click ‘Protocols for <instance name="">’.
<Instance Name> is the name of the instance of Microsoft SQL Express being used by the GFI product.
Right-click ‘TCP/IP’ and then click ‘Enable’. The icon for the protocol will change to show that the protocol is enabled.
this link will be helpful showing the pictorial representation of how to enable remote connection in SQL Server 2005
http://www.webxpert.ro/andrei/2009/05/31/enable-tcpip-on-sql-server-2005-express-edition/[
^]
I hope the above solution works for you.