SQL Server 2014
SQL Server Management Studio
IMPORTANT: With SQL 2016, the Management Studio application is now a completely separate stand-alone product from the SQL Server database engine.
- SQL Server Management Studio 2016 is compatible with all versions of SQL Server and can be downloaded at the link below:
- https://msdn.microsoft.com/en-us/library/mt238290.aspx
- Next, Click the blue download link labelled "Download SQL Server Management Studio (16.5.1)".
- A pop-up will appear, click Save File to save to your computer.
Versions of SQL Server Management Studio older than the 2014 version may be able to connect and run queries. However, most functions will require that you use the 2014 version of Management Studio. In order to obtain SQL Server Management Studio 2014, first go to the following URL:
https://www.microsoft.com/en-us/download/details.aspx?id=42299
Next, select the orange download button. A new pop-up will appear. Scroll down to the very bottom. If you have a 32-bit Operating System, select the check box next to the following and choose 'Next':
"MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe"
If you are running a newer 64-bit Operating System, select the check box next to the following and choose 'Next':
"MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe"