a) Open the node that reads "SS2005",
b) Click on "Database Engine"
c) You should see an option that reads "Remote connections"
d) Click on "Remote connections" and choose the "Local and Remote connections"
And in 2008, you would go to SQL Server Configuration Manager - SQL Server Network Configuration, and then
choose the Protocols for the appropriate server. Enable the TCP/IP protocol. Restart the SQL Server service.
On the same note, your connection string should look like:
<add name="myConnectionString";Integrated Security=true
connectionString="Data Source=server database=Northwind;" />
The connection string can be found in your web configuration file. (web.config)
Hope it helps.