I have Visual Studio 2008 Professional installed. I just installed SQL Server 2008 Express. I'd like to think I'm a pretty capable computer person but I can't seem to connect to SQL Server period. Clearly I haven't configured something properly but I don't know what it is.

In visual studio I click on "Add Connection" then select "Microsoft SQL Server". In "Server Name" I select the only instance shown (MAIN-PC) and under databases there are none shown. When I click "test connection" I get...

The server was not found or was not accessible.......