SQL Server is a relational database management system (RDBMS) developed by Microsoft. SQL Server supports ANSI SQL, which is the standard Structured Query Language. However, SQL Server comes with its implementation of the SQL language, T-SQL (Transact-SQL). It is primarily designed and developed to compete with MySQL and Oracle databases.
You must have completed the following tasks:
- Ensure that you have a windows machine or VM to install the SQL server.
- Dowloaded the SQL Server installation file for Windows. For more information refer to SQL Server downloads site.
- Installed the .Net Framework, 1GB of recommended memory, and NTFS system.
-
Open the downloaded .exe file.
The installation wizard opens.
-
Click the edition that you want to install.
-
Read the license terms and conditions and then click Accept.
-
Browse to choose the path for installation or enter the file path and then click Install. The installation package is downloaded first and then the installation will start. Once installation is completed successfully, the following window is displayed:
You can perform the following actions on the Installation has completed successfully! window:
- Instance name: This is by default labeled as MSSQLSERVER.
- Connect now: Click this button to open a separate command line window for connection testing of what we have just
installed.The system will run by default ‘select @@Version’ statement to confirm that we can connect to new MSSQLSERVER instance successfully.
- Customize: Click this button to open the SQL Installation center to customize further and add feature other than which are there as a part of the BASIC installation.
- Install SSMS: Click this button to go to Microsoft SSMS download link.
- Close: Click this button to close the window.
You have successfully installed the SQL Server on Windows.