2

I have recently successfully completed the installation of SQL Server 2008 Express.

After installation when I tried accessing SQL Server Express I found there was no Management Studio installed.

Is there an issue with express, that Management Studio is not installed during installation?

If yes how do we access SQL Server in this case?

I also tried installing Management Studio separately but however when I tried to login through the installed Management Studio the server was not found.

Am I missing something?

Does SQL Server Express not come with Management Studio?

Please Assist. Thanks

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
tejas
  • 43
  • 2
  • 4
  • 1
    If you look at the [SQL Server Express download page](http://www.microsoft.com/en-us/download/details.aspx?id=29062), you'll see several "versions" of SQL Server Express. The "bare bones" version is just that - nothing but the actual SQL Server engine. But there's also the "Express with Tools" and the "Express with Advanced Services" versions - both of which **do include** SQL Server Management Studio Express. But you can also download the Mgmt Studio Express separately and install it. – marc_s Sep 17 '13 at 20:37

2 Answers2

2

sql server 2008 express does not have management studio. There is a Management Studio Express, but, IIRC, it must be downloaded separately.

  • Agreed. "Tejas" installed the ENGINE, not SSMS. SSMS "Express" is avaiable...just go get it. – granadaCoder Sep 17 '13 at 18:08
  • 1
    The "Express with Tools" and "Express with Advanced Services" versions of SQL Server Express **DO** include the Management Studio Express ! – marc_s Sep 17 '13 at 20:38
  • 1
    Installing "Express with Advanced Services" solved the issue thanks all for your help – tejas Sep 18 '13 at 04:11
0

The SQL Server 2008 Management Studio Express can be downloaded from here. You'll need it to use a management studio with Express edition.

brazilianldsjaguar
  • 1,409
  • 1
  • 20
  • 45