How to connect SQL Server 2008 Express?

Question

I can't connect SQL Server Express 2008,I downloaded and installed SQL Server 2008 Express 64Bit, Microsoft SQL Server Management Studio.

And I can't connect to the SQL Server, I tried those options

Disable the firewall
Restart the SQL Server Service at Sql Server Configuration Service, I have two services that aren't working - SQL Server Agent, SQL Server Browser, only SQL Server is running.

Here is the picture of the message - http://i46.tinypic.com/2zjj051.png

score 7 · Answer 1 · answered Mar 04 '10 at 22:11

7

You have to connect to the named instance.

Try connection to .\SQLEXPRESS or swap that out with the name you used for the default instance.

answered Mar 04 '10 at 22:11

Chris F

1

Make sure you're not trying to connect to it remotely. It only works locally. – Keith Adler Mar 04 '10 at 22:12
@Nissan remote connections are disabled by default, but can be enabled: http://support.microsoft.com/kb/914277 – Michael Niemand Apr 09 '10 at 13:17
+1 because it doesn't look like you'll get your answer accepted :( – SqlRyan Jun 16 '10 at 13:56

1 Answers1