I have just started using Visual Studio and SQL Server - I mean just. And I can't do the most basic thing, which is more than frustrating. I've checked the KnowledgeBase and surprisingly did not find a similar question (I suppose I must be really remedial then).
I am trying to add a SQL Server Express db as a data source. It's errored out with the following messages (I am trying out both VS 6.0 & VS 2008):
In VS 6.0, I get this error:
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections.
Named Pipes Provider: Could not open a connection to SQL Server 
In VS 2008, I get a similar error.
I've tried different things, but I got nowhere. Please help! It's like it's Christmas, I've got this huge present, but I can't get the wrapping off the package! :(