up vote 1 down vote favorite
share [g+] share [fb]

I'm installing (well trying to) SQL server express 2008 SP1 on Windows 7

This is not working for me.

I started by installing VS2010 B2, it installed SQL 2008 Express.

I went into the 'SQL Server Configuration Manager' and enabled the TCPIP protocol and Named Pipes under 'SQL Server Network Configuration' for the SQLExpress instance.

I then installed SSMS. When I try to connect to localhost, I get:

alt text

I am at wit's end here. I'm sure this is a duplicate. I'm on Windows 7 64-bit and I'm installing 64-bit SQL versions when they are available.

link|improve this question
94% accept rate
Have you (re)started SQL Server services ? Try rebooting Windows. – Sathya♦ Dec 28 '09 at 5:26
feedback

1 Answer

up vote 3 down vote accepted

Make sure you're giving the full server instance name. For me it was \SQLEXPRESS. I got the same error until I added the computer name.

link|improve this answer
Agreed. It should be computer_name\SQLEXPRESS, or localhost\SQLEXPRESS if connecting to the same computer as SQL Server is installed on. – kez Feb 6 '10 at 19:11
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.