Installing SQL Server 2014 Management Studio (SSMS)

SQL Server 2014 is downloaded and installed the first time you install SixBit (3.0 Versions and up). This is the bare minimum required to run the SQL Server database. SQL Server Management Studio (SSMS) is an add-on to SQL Server that allows users with some database experience to open and view their databases as well as create reports, stored procedures, etc.

If you are having difficulty sharing databases between two computers, having Management Studio installed can be very helpful for support in diagnosing the problem.

Downloading SQL SSMS 2014 Step by Step Guide:

To download SQL Server 2014 SSMS first go to Hanselman's website for hosting Microsoft SQL Server Products: Hanselman's Website for SQL Server Downloads

Next, click on the link for SQL Server 2014 Management Studio depending on your system type: 

 

SSMS 2014 DL Link

 

You can find your system type/architecture by clicking your Windows Start button/charm, typing in My PC, then right-click My PC and choose Properties. You will see the following window:

system type / architecture

 

Once the download has fully completed double click and run it. Finally, choose to Install SSMS as a new instance during the installation process.

 

  • Installation, Installing SQL Server Management Studio, Management Studio, Installing SSMS, SSMS 2014
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

"Error reading setup initialization file" during installation

Background: The SixBit installation is a single exe file that gets downloaded to a user's...

Error - Could not load file or assembly 'Microsoft.SqlServer.Smo"

Background:As part of our SixBit installation, we download and install a copy of SQL Server 2008...

Error 27502: SQL Server 2008 R2 failed to install during SixBit Installation

Background:As part of our SixBit installation, we download and install a copy of SQL Server 2008...

Error 27506: The server could not load DCOM (7404)

Background:As part of our SixBit installation, we download and install a copy of SQL Server 2008...

Installation doesn't recognize SQL Server and causes reboot loop

Background:SQL Server 2008 R2 provides the database component for SixBit. The first time you...