SQL Server Applications
There are many applications that are or can be installed to help configure SQL Server. The following are the main ones referred to in this document.
SQL Server Management Studio
SQL Server Management Studio provides all the tools to create databases, tables, views as well as setting up users and security.
Management Studio is not installed by default with SQL Server. It must be downloaded and installed separately.
Once installed, SQL Server Management Studio is available from the Microsoft SQL Server program group.
SQL Server Configuration Manager
SQL Server Configuration Manager provides the tools to manage the SQL Server instances in the Windows operating system.
This is installed with SQL Server. In some versions it is available in the Microsoft SQL Server program group by selecting SQL Server Configuration Manager. In other versions it needs to be launched manually. For example, to launch the Configuration Manager for SQL Server 2016, from Start, enter SQLServerManager13.msc. The 13 is the version of SQL Server so this will change based on what SQL Server version is installed.
If this does not work, open Windows File Explorer and look for SQLServerManagerXX.msc in either C:\Windows\System32 or C:\Windows\SysWOW64.