I spent pretty much all today wiping a desktop, and installing Windows 7, Visual Studio, and SQL Server Express 2010 on it. Talk about some form of hell.
The WIndows 7 install went fine, The Visual Studio install went fine. The SQL Server Express install went fine. Thought I was in heaven.
So I fire up SQL Server Management Studio and this is what I see:
Makes sense, I hit the Connect button. After about 5 seconds, I see get an error:
Of course the information is correct, I’m on my local box, how can you not connect to it? Bah.
Turns out, I got the server name wrong. It should be either <MACHINENAME>SQLEXPRESS or .SQLEXPRESS.
Then it all works like magic.