• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

Sql server 2008 express

Hi Expert,

I downloaded and installed Microsoft Visual Web Developer 2010 Express, it works fine and I can make .mdf database in database explorer, but i don't have sql management studio and report services, do I need download sql server 2008 r2 express again?


From my machine,  all programs, I can see Sql server 2008 r2 on the list, they have  import and export data and configuration tools, no sql management studio

I use window 7

Thanks in advance.
0
dshi15
Asked:
dshi15
  • 5
  • 3
4 Solutions
 
Ephraim WangoyaCommented:

You need to install the management tools

Just run the setup for SQL Server 2008R2 again, but this time only select management tools from the modules to install.

http://www.microsoft.com/express/Database/
0
 
dshi15Author Commented:
thanks, I went above link and downloaded and run and I select add new features to existing instance of sql server 2008 r2 and click on next, it has error, it not let me select features.
0
 
dshi15Author Commented:
I want give you a screen shot to you, but I don't know how?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
dshi15Author Commented:
this time I picked 'add new or add shared features' then it run successful, but after I restart my machine, I still can not see management studio under sql server 2008 express r2?
0
 
Alpesh PatelAssistant ConsultantCommented:
No, Down load SQL Server Express 2008 R2 with Advance tool. It come with BIDS and Reporting Service. Install it again.
0
 
dshi15Author Commented:
PatelAlpesh:  I already went this  site  http://www.microsoft.com/express/Database/ and downloaded and installed. What is next? Thanks.
0
 
Ephraim WangoyaCommented:

I'm not sure why you are not getting the option, you can download SSMSE only from  here
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en

or try running the setup again
When setup asks to Specify a free edition, select Enterprise Evaluation and only select Management Tools
0
 
dshi15Author Commented:
which one I need download SQLManagementStudio_x64_ENU.exe or SQLManagementStudio_x86_ENU.exe?
0
 
Ephraim WangoyaCommented:

if you have a 64 bit system then
SQLManagementStudio_x64_ENU.exe

32 bit system
SQLManagementStudio_x86_ENU.exe
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now