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?
genusysAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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 ChenProblem resolverCommented:
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
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

HuaMin ChenProblem resolverCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.