Solved

SQL Server Management Service 2012

Posted on 2016-08-24
19
35 Views
Last Modified: 2016-08-28
Hi,
I need to install  SQL Server Management Service 2012.
However, when searching I get results for

SQL Server Management Service 2012 EXPRESS.?
Is that the same thing?

If not, could you please let me know where I could simply get/download:

SQL Server Management Service 2012...

Searched on MSDN for:
SQL Server Management Service 2012

And got 60,500 results just with the "downloads" filter selected.....

Any relevant direction would be greatly appreciated.....
Thank you very much....
0
Comment
Question by:GST-GRIDTECH
  • 6
  • 6
  • 6
  • +1
19 Comments
 

Expert Comment

by:Christian Eromosele
ID: 41768807
Dear Gst,

You can download the management studio by following instruction on SQL Server Management Service 2012 EXPRESS.

Just expand and select Management studio only. This should help you.

Cheers
0
 

Author Comment

by:GST-GRIDTECH
ID: 41768859
Ok
So I'm at
Microsoft.com/en-us/download/details.aspx?id=29062
I  will download just...
ENU\x..\SQLManagementStudio_x..ENU.exe

Correct???
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 41768866
Correct???
Yes.

Btw, what edition and version of SQL Server do you have already installed?
0
 
LVL 69

Expert Comment

by:Éric Moreau
ID: 41768870
you should install SSMS 2016 which is compatible with the 2012 server from https://msdn.microsoft.com/en-us/library/mt238290.aspx
0
 

Author Comment

by:GST-GRIDTECH
ID: 41768897
Hi ViTor. This organization seems to have a few versions of SQL Server installed. They have many developers running multiple versions of SQL Mgmt Studio
0
 

Author Comment

by:GST-GRIDTECH
ID: 41768901
Hi Eric,
since the user, specifically asked for 2012, that's what he'll get.
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 41768907
This organization seems to have a few versions of SQL Server installed. They have many developers running multiple versions of SQL Mgmt Studio
So when they installed the SQL Server why didn't they installed the Management Studio as well? It's only a check box that need to be ticked.
0
 
LVL 69

Accepted Solution

by:
Éric Moreau earned 300 total points
ID: 41768919
if you really want to install SSMS 2012, you will need to download the full SQL Server 2012 package matching your edition from MSDN (https://msdn.microsoft.com/en-us/subscriptions/downloads/#searchTerm=&ProductFamilyId=461&Languages=en&FileExtensions=.exe&PageSize=10&PageIndex=0&FileId=0) and when you will launch the installation, just select SSMS.
0
 

Author Comment

by:GST-GRIDTECH
ID: 41768928
Hi Eric

Will the user need a login for that MSDN site to download???
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 69

Expert Comment

by:Éric Moreau
ID: 41768936
unless you need the express edition, yes a login is required

SSMS 2016 download does not require login
0
 
LVL 45

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 200 total points
ID: 41768938
I guess the SSMS 2012 for Express is good enough. Why download full version if you can download only the necessary component?
0
 
LVL 69

Expert Comment

by:Éric Moreau
ID: 41768940
Installing SSMS Express will prevent the use of more advanced features if they are not using the server Express edition.
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 41768967
@Éric: Which features are you talking about? As far as I know there's no differences in SSMS from which Edition you get it from.
0
 
LVL 69

Expert Comment

by:Éric Moreau
ID: 41768994
I remember with the first release of SSMS Express 2012 that features like full text, Maintenance plans, ... (features not available in Express) were not available.
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 41769006
I confess that I never installed a SSMS from a Express Edition but I'm not expecting that Microsoft would make two versions of the product. After all the limitations should be imposed by the engine itself and not the GUI.
If it is as you said then means that Microsoft doesn't believe that SQL engine can control those edition limitations and that's a fail.
0
 
LVL 69

Expert Comment

by:Éric Moreau
ID: 41769022
but at the same time, why install features that are not relevant for a great number of installations?

they fixed that in 2016. there is now a single installation for SSMS that connects to all editions including Azure.
0
 

Author Comment

by:GST-GRIDTECH
ID: 41769091
Hi Vitor
Sorry
Just noticed your question on why they didn't install SSMS at the time.

This install of SQL Server Mgmt is going on the local desktop for a new employee.
I'm myself am not familiar at all with the SQL environment here.
I was just asked to find and install SQL Server Management Service 2012........
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 41769832
Ok. As you can see you have three options:

  1. Install SSMS that comes with MSSQL 2012 Express Edition (less files to distribute)
  2. Install SSMS that comes with MSSQL 2012 Standard Edition (you need to distribute all MSSQL media)
  3. Install SSMS 2016 (less files to distribute but you don't want to provide them different version from 2012)
0
 

Author Closing Comment

by:GST-GRIDTECH
ID: 41773969
thank you
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

708 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now