Use SQL Server Management Studio as the administrative interface for SQL Server. You need to install SQL Server Management Studio when you install SQL Server on the computer. Occasionally, SSMS may not get initially installed. In such a case, you should install using the SQL Server installation media (CD or downloaded file). The existing SQL Server installation needs modification to include all components.