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

SQL Management Studio

I am trying to install the SQL Server Management studio on a Win 7 64 bit machine. I download the file SQLManagemenetStudio_x64_Enu.Exe from Microsoft but, the only shared feature is the "SQL Client Conectivity SDK" which is grayed out.  What am I doing wrong?
0
genusys
Asked:
genusys
  • 8
  • 8
  • 2
  • +1
1 Solution
 
Salah Eddine ELMRABETTechnical Lead Manager (Owner)Commented:
Hi,

Did you check that PowerShell is available on your machine?

Also for .Net 3.5 it's better to make sure it's installed before lanching the SSMS setup to save time.

Also SSMS Depends on Visual Studio 2010 IDE

For mote details regarding the Requirements have a look here:

https://msdn.microsoft.com/en-us/library/ms143506.aspx

Best regards.

Salah
0
 
genusysAuthor Commented:
I will check both Powershell and .NET 3.5 first thing in the morning
0
 
HuaMin ChenSystem AnalystCommented:
Try to take Express version and further choose the one with Advanced options from that.
http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
HuaMin ChenSystem AnalystCommented:
Try to take this

ENU\x64\SQLEXPRADV_x64_ENU.exe

from the following
https://www.microsoft.com/en-US/download/details.aspx?id=29062
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Where did you download the file from?
0
 
genusysAuthor Commented:
File was downloaded from http://www.microsoft.com/en-us/download/details.aspx?id=30438
The official MS Site
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
That's correct. Do you have any other version of SQL Server already installed?
And can you post a screen shot of the features to install?
0
 
genusysAuthor Commented:
There is no other version installed. The installation screen looks like the attached file.
Mgmt-Studio-Install.PNG
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, that's weird.
This may sounds like a stupid question but you chose "New installation or add Features" in the Installation Type screen, right?
0
 
genusysAuthor Commented:
Yes.
0
 
Salah Eddine ELMRABETTechnical Lead Manager (Owner)Commented:
Hi
do you visual studio installed? I asked for this also!

If you don't visual studio install it and reboot then start management studio setup

regards

salah
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
What for he needs Visual Studio?
I have SSMS installed in hundreds server and none have Visual Studio.
0
 
genusysAuthor Commented:
I shouldn't need visual studio. SQL Server. SQL Express runs without it.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Can you download the 32bit version and try to install it? Just to see if that version works properly.
0
 
genusysAuthor Commented:
Of the Mgmt. Studio?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes. Just to see if there's any difference from 64bit version.
0
 
genusysAuthor Commented:
It doesn't install at all. Gives an error about not compatible.  I'm going to uninstall and re-install using the WT download. I doubt it will make a difference. Could it be a service pack?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I don't think so.
You can also download SSMS 2012 since it's an higher version and works with previous versions as SQL Server 2008R2.
0
 
genusysAuthor Commented:
I'm going to do that next. The application vendor recommended 2008. I assume their experience is that it is more stable with their product.  You've been very helpful.  I'll update you later today.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
SSMS is not SQL Server. It's only a friendly interface (GUI) to help administering SQL Server and that's why I'm recommend you an earlier version since you can still work on SQL Server 2008R2 or previous versions with SSMS 2012. There is no impact at all.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

  • 8
  • 8
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now