Installation of SQL Server and Management Studio
Structured Query Language Server (SQL) installation can be done in two ways ; by running the entire process on the local host without other SQL Server resources and by Installation via configuration files. Whichever method you will prefer depends solely on you. However we will be dealing with the two installations in this artifact.
SQL Server Management Studio Installation on Local Computer?
This approach involves you installing your SQL Server Management Studio directly from the CD or copying the installation setup to your desktop, for more details click on this website. To install SQL you need to follow this step; Open the Server Installation Center, select "Install,” then "Create a new standalone SQL Server installation" or "Add features to an existing installation".
Note: You must select to install the SQL Server role in the new Setup-configuration window that opens. Select install SQL Server Components, and click "Next" button: this leads you to another window. Select the "Basic Tools and Management to Complete" option. Click next to continue the process. Before entering the Ready to Install window, you must click this button multiple times without selecting other options but only accept the licensing terms. This eventually takes you to "Ready to Install" page, where you can access the file configuration path. Install the SQL Server Management Studio without changing the configuration settings. Next click "install" for the installation to be successfully completed which ends with a confirmation message - "Complete". Now, go to start menu, click program to Recently Installed Programs, there you will find your SQL Server Management Studio. So start creating and querying your databases!
SQL Server Management Studio Installation from the Configuration file ?
SQL Server Management Studio can also be installed on the computer via configuration file that was created during the previous installation of the source device. However, this method is quicker than the other. Here are the steps to take:
Run "cmd.exe" on your computer, then Enter the following in your command prompt C: User Manager> i: setup.exe / ConfigurationFile = "C: Program Files Microsoft SQL Server 120 Installation Log Log 20170611_124546 / Configuration File.ini" / Q / IAcceptSQLServerLicenseTerms= "True". Be sure to specify the SQL Server media installation method and the configuration file. After the installation go to the start menu as done previously.