I hope its ok to post this question here...

I've installed SQL Server 2005 on Vista and I can log in fine via Management Studio with the 'sa' account. However, when I used the same details in web.config...

<add key="Main.ConnectionString" value="data source=localhost;initial catalog=bangfaceweekender;User ID=sa;Password=p"/>

I just get the classic error...

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Now I've enabled remote connections with the 'Surface Configuration Tool'. Is there something I'm missing here?

Cheers, Ian.

Oh, everyone can relax, I forgot that my app has two connection strings.

Actually, might as well delete this thread.