Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Sql express Issues

Posted on 2011-02-25
11
Medium Priority
?
370 Views
Last Modified: 2012-05-11
Hi There,

Ok I have not been working on SQL and .NET for a couple of years.  Well I want to reinstall SQL and in particular have the managment studio. I have no idea how to get it back. I have downloaded a number of "versions" but there appears to be no where to install or add the management studio... could someone help me get this up and running. I have a database I want to mount but alas alak I cant.

Kind Regards

Simon
0
Comment
Question by:si2030
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
  • 2
11 Comments
 
LVL 15

Accepted Solution

by:
derekkromm earned 1200 total points
ID: 34985253
0
 
LVL 79

Assisted Solution

by:arnold
arnold earned 300 total points
ID: 34985257
Express versions often do not include the Studio Management Express.  There is a larger download that includes the SSMSE in your case you can download the SSMSE install from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b
0
 

Author Comment

by:si2030
ID: 34985275
I have a version installed already.  do I unistall or can this download overwrite... further I also have alot of other items - see attached jpg. I assume this is part of the install I currently have... what do I do with these.. leave and the download above will takecare... etc

Simon
SQL-items-installed.jpg
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 15

Expert Comment

by:derekkromm
ID: 34985286
I would download from the link and, if prompted, just install client tools/management studio and none of the core database objects.
0
 

Author Comment

by:si2030
ID: 34985366
Ok I have come back to the road block I ecountered before... there apears to be no where to actually include the management studio..

I also got a message about possible compatablity issues.  I would have thought that this was the latest update and thus wouldnt need to require another upgrade to service pack 2....

I have include two jpgs to display my issues...

KInd regards
Simon
SQL-items-installed.jpg
Comaptablility-issues.png
0
 

Author Comment

by:si2030
ID: 34985372
Sorry not the file I wanted to include..

 so here it is...
Features.png
0
 
LVL 79

Expert Comment

by:arnold
ID: 34985413
Install and then apply the SP1 update to the database and ssmse.
0
 

Author Comment

by:si2030
ID: 34985523
Hi there,

Well I downloaded SP1 and took the option to add features.  Well the management studio is not available or even exists on this screen.  (see file attached)... So I have tried SP1 SP2 and in none of the instances does the management studio display... what can I do now..

Kind Regards

Simon
options-with-SP1.png
0
 

Author Comment

by:si2030
ID: 34985889
Any idea on this?
0
 
LVL 15

Expert Comment

by:derekkromm
ID: 34987859
can you see if you have the following path?

C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe

or an equivlalent

or do a file search for ssms.exe
0
 

Author Closing Comment

by:si2030
ID: 34989769
I dont know why it didnt want to install but in the end I downloaded the option with advance services... in effect everything. I then uninstalled everything that had SQL in the heading... I then reinstalled. this time I got the option for Management Studio Express and included it.

It installed fully and correctly except for an error right at the very start.

"An error occured creating the configuration section handler for user settings/Microsoft .SQLServer.configuration.LandingPage.Properties.Settings: Could not load file or assembly........so on"

Anyway I decided to push on and it worked...

Thanks to those that took the time to help. Simon
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question