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

x
?
Solved

What Version of SQL Server Management Studio is compatiable for Windows Server 2012

Posted on 2014-02-19
9
Medium Priority
?
1,764 Views
Last Modified: 2014-02-21
Hi Experts

I've been looking for definite answer here and on the web with no luck. We have a new Windows Server 2012 that I'm in the works of setting up, its an HP Proliant ML350 G6 and I've installed HP Insight Manager 7.3 which installed for itself MS SQL Server 2008 R2, Ver 10.52.4000.

Its my understanding, I need to install a SQL Server Management Studio in order to correctly  change the Username and Password for the Admin of the database.

  I downloaded SQL Server Management 2008 Version 10.0.1600.22 x64. but when I attempt to install it I get .Netframeworks exceptions right away. I noticed on the MS Download page that requirements do not have Windows Server 2012 listed, but nor does the SQL Server Management Studio 2012..

My question is what version do I need to be able to install Studio on my Windows Server 2012 Server and work with the SQL 2008 R2 database instance created by HP SIM?
0
Comment
Question by:CATHY-IT
[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
  • 5
  • 3
9 Comments
 
LVL 23

Accepted Solution

by:
Patrick Bogers earned 2000 total points
ID: 39871261
SSMS2008 Should be fine, did you install it on the server or on a workstation?
0
 

Author Comment

by:CATHY-IT
ID: 39871282
On the Server.. Should I be doing it on the Workstation.

I have nil experience working with SQL databases, usually I've ran installs that include them and they work and that's it..
0
 
LVL 23

Expert Comment

by:Patrick Bogers
ID: 39871298
You can install it both ways, on server or workstation.
If hp installed SQL server, is the SSMS by any chance not also installed?
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:CATHY-IT
ID: 39871323
Not that I can see it under the New Start List of Apps. and I did look up the usually location of the SSMS location and no files exist in the folder within the MSSQLSERVER folder and I also had done a windows search for the executable ssms.exe.. nothing found
0
 
LVL 23

Expert Comment

by:Patrick Bogers
ID: 39871347
OK. We can persue why SSMS 2008 is not installing or you can simply install SSMS 2012 on the server.
If remote management is desired i would go for a workstation install.
0
 

Author Comment

by:CATHY-IT
ID: 39871361
Ok. so both are suppose to work then.. K.. I didn't want to spend time troubleshooting the .Net frameworks error is the version was not even compatible. I'll download 2012 version and report back.. thanks
0
 
LVL 83

Expert Comment

by:David Johnson, CD, MVP
ID: 39872144
Don't forget to add the windows feature .net 3.5.1 and powershell
0
 

Author Comment

by:CATHY-IT
ID: 39878141
Sorry about the delay.. one person Tech Dept here... I noticed when doing a trial run of install on a older unit that it wanted to install another Instance SQL database I really didn't want to clutter our Server with another instance. I found a forum stating that a particular SQL Server Management Studio 2008 with link to get it from MS, would install only the Studio I tried that one and got it installed ok, though I just ignored the initial error message. It did install the 2008 version of SQL and the HP SIM one is 2008 R2 version, but I don't see another Database service loading.  I got the Username/Password issue corrected. Thank you
0
 

Author Closing Comment

by:CATHY-IT
ID: 39878143
This respond did answer my questions, and Using that I got what I needed done. thanks
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to deal with a specific error when using the Enable-RemoteMailbox cmdlet to create a mailbox in the cloud-based service, for an existing user in an on-premises Active Directory.
In this Micro Tutorial viewers will learn how to use Windows Server Backup to create full image of their system. Tutorial shows how to install Windows Server Backup Feature on Windows 2012R2 and how to configure scheduled Bare Metal Recovery backup.…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

688 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