3

I have installed SQL Server 2008 R2 Express. I have also installed SQL Server Management Studio. I cannot connect to my localhost\sqlexpress server using SSMS. However, I can connect via Visual Studio 2010. I can also connect to my SQL Azure database from within visual studio but cannot from SQL Server Management Studio.

Any help or direction would be great...

EDIT: I use the localhost\sqlexpress instance in Visual Studio 2010 through Server Explorer and it works fine. Basically it seems like an SSMS bug?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Brian
  • 91
  • 1
  • 5

2 Answers2

2

For SQL Azure you need SQL Management Studio from 2008 R2 (earlier versions can't connect to azure).

For local connection you can also use . (dot) or .\SQLEXPRESS.

Matej
  • 7,517
  • 2
  • 36
  • 45
1

What name are you using for servername? You need to use Computer-Name\SQLEXPRESS for the server name in the logon prompt.

Mitch Wheat
  • 295,962
  • 43
  • 465
  • 541