No Management Studio seen after SQL Server 2008 Express installation

sql sql-server sql-server-2008 ssms sql-server-2008-express
tejas picture tejas · Sep 17, 2013 · Viewed 8.5k times · Source

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

Answer

user804018 picture user804018 · Sep 17, 2013

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

Related questions

SQL Server 2008: how do I grant privileges to a username?

I need to be able to establish an ODBC connection through SQL Server authentication. In SSMS how do I grant permission for a user to be able to have ALL RIGHTS on a specific database? is there a way to …

Read More
How do I grant myself admin access to a local SQL Server instance?

I installed SQL Server 2008 R2 to my local machine. But, I can't create a new database because of rights (or lack of). "CREATE DATABASE PERMISSION DENIED" So, I tried to assign the admin privileges to my current login "User does …

Read More
Converting Select results into Insert script - SQL Server

I have SQL Server 2008, SQL Server Management Studio. I need to select data from Table1 in database1. Then I have to edit some values in the results and insert values into Table1 in database2. Or let me put it other …

Read More