Difference between revisions of "SQL Server 2014"

From Hostek.com Wiki
Jump to: navigation, search
(Created page with "==SQL Server Management Studio== Versions of SQL Server Management Studio older than the 2014 version may be able to connect and run queries. However, most functions will re...")
 
m (SQL Server Management Studio)
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
==SQL Server Management Studio==
 
==SQL Server Management Studio==
  
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. The 2014 version can be downloaded at the following URLs:
+
<pre>IMPORTANT: With SQL 2016, the Management Studio application is now a completely separate stand-alone product from the SQL Server database engine.</pre>
  
64-bit download:<br />
+
*SQL Server Management Studio '''2016 is compatible with all versions''' of SQL Server and can be downloaded at the link below:
http://download.microsoft.com/download/E/A/E/EAE6F7FC-767A-4038-A954-49B8B05D04EB/Express%2064BIT/SQLEXPR_x64_ENU.exe
+
*#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.
  
32-bit download:<br />
+
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:
http://download.microsoft.com/download/E/A/E/EAE6F7FC-767A-4038-A954-49B8B05D04EB/Express%2032BIT%20WoW64/SQLEXPR32_x86_ENU.exe
+
 
 +
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"
  
 
[[Category:Databases-MSSQL]]
 
[[Category:Databases-MSSQL]]

Latest revision as of 23:05, 16 December 2016

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:
    1. https://msdn.microsoft.com/en-us/library/mt238290.aspx
    2. Next, Click the blue download link labelled "Download SQL Server Management Studio (16.5.1)".
    3. 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"