How to install sql server 2014 management studio

There are multiple editions of SQL Server 2014 (Enterprise Edition, Enterprise bộ vi xử lý Core Edition, Business Intelligence Edition, Standard Edition, Web Edition, ExpressDeveloper Edition). Squốc lộ Server 2014 has a miễn phí edition – Express & while the hệ thống itself lacks some options that other editions have, SQL Server 2014 Management Studio is the same và can be used with each of these.

Bạn đang xem: How to install sql server 2014 management studio

Obtaining the installation file

The entire SQL Server Express edition can be downloaded from this link, however, for downloading only SQL Server 2014 Management Studio, clicking the Download button will present a các mục of all files the complete installation is contained of, but you’ll need only one of these:

The bottom two files are MgmtStudio 32BITSQLManagementStudio_x86_ENU.exe MgmtStudio 64BITSQLManagementStudio_x64_ENU.exe & you should choose one of these according to the operating system running on the machine(32 or 64 bit), on which SQL Server Management Studio will be installed.

If you aren’t sure which operating system type is installed on your machine, you can check it by right-clicking in My Computer>Properties. The current operating system will be specified under System type.

After selecting the desired file, cliông xã on the Next button in the bottom-right corner và the tải về will begin.

Xem thêm: Cài Đặt Plugin Cho Máy Tính ? Bật Adobe Flash Trong Microsoft Edge


The downloaded tệp tin should be in .exe cộ format with kích cỡ of approximately 650 MB. Double-cliông chồng on it khổng lồ run the installation:

The window for choosing directory to which the extracted files will be saved is shown. After choosing the directory cliông chồng the Ok button & extraction will begin

The next step is the Global Rules. Setup Global Rules identify problems that might occur when installing Squốc lộ Server 2014. Which rules are those in some extent depends on which operating system you are installing lớn but usually include the following: Whether the logged-in user is a system administrator with appropriate privileges (a must be) Whether there are any reboots pending from other installers Whether required .NET components are available Whether there is support for long pathnames where the installation media resides Install Setup Files and Install Rules steps are automatically processed. However, the Install Rules is yet another step where the thiết lập wizard is checking if certain software requirements are met: Need for reboot in order for changes to apply Whether there are some previous releases of SQL Server Validation of SQL Server registry keys Whether the computer is a tên miền controller After you proceeded on the Next button, Feature Rules and Feature Configuration Rules steps will be processed automatically if all the Feature Rules are met: Prior Visual Studio 2010 instances requiring update

Installing Squốc lộ Server 2014 Management Studio with previously installed Squốc lộ Server 2014

If you’re installing SQL Server Management Studio on the machine on which there is a previously installed Squốc lộ Server, there will be minor differences và an additional step in the installation process:

First step will be the Global Rules instead of License Terms.

The final difference is that instead as a first step, License Terms will follow the Installation Type. In order to proceed with the installation, read the license terms và then check the I accept the license terms checkboxFor the rest of the installation, continue from the step number 7, as these are identical

Whichever type of installation you’re performing, after the installation is finished, on the Cthua button the installation wizard will cthua trận and your Squốc lộ Server Management Studio will be mix for the first use.

Xem thêm: Bắn Súng Arena Arena: Trò Chơi Bắn Súng Sơn Tây Hồ, Bắn Súng Arena Arena: Trò Chơi Bắn Súng

Now that you have sầu installed Squốc lộ Server 2014 Management Studio, you can update this software with some không tính tiền add-ins from ApexSQL that will add formatting, auto-complete, refactoring and tìm kiếm capabilities. Cliông chồng here to see how to install these.

Chuyên mục: Công nghệ